Learn LibreOffice Calc - Revision history

Prateek: /* Installation */

2022-09-26T11:29:32Z

Installation

Arjun: /* Inserting formulae for computations */

2022-07-13T06:25:51Z

Inserting formulae for computations

Arjun: /* Freeze or Unfreeze rows and columns */

2022-07-13T06:25:17Z

Freeze or Unfreeze rows and columns

Arjun: /* Working with the application */

2022-07-13T06:21:45Z

Working with the application

Rakesh: /* Inserting a new sheet */

2022-07-11T10:00:51Z

Inserting a new sheet

Rakesh at 10:00, 11 July 2022

2022-07-11T10:00:20Z

Show changes

Arjun: /* Inserting formulae for computations */

2022-07-11T09:52:24Z

Inserting formulae for computations

Arjun: /* Basic information */

2022-07-11T09:46:36Z

Basic information

Arjun: /* Advanced features */

2022-07-11T09:13:42Z

Advanced features

Arjun: /* Introduction */

2022-07-11T09:03:28Z

Introduction

@@ Line 36: / Line 36: @@
 Spreadsheet application is used for recording, processing and analyzing data. It is also used for creating text and graphical outputs. The application has many arithmetical, statistical, text processing functions which make it a very powerful desktop tool. Data can be sorted, filtered and processed into outputs, including multi-variate tables.
-===Installation===
+==== Installation ====
-====For Ubuntu OS====
+Please click on the below link to learn about LibreOffice Installation & Configuration
-==== For Windows OS ====
+[https://teacher-network.in/OER/index.php/LibreOffice_Installation_and_Configuration Click here]
 ===Working with the application===

@@ Line 140: / Line 140: @@
 ==== Freeze or Unfreeze rows and columns ====
 If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">
 File:LO Calc 2 Freeze rows and columns.png|Freezing the cells
@@ Line 148: / Line 146: @@
 {{clear}}
-=== Inserting formulae for computations===
+==== Inserting formulae for computations====
 <gallery mode="packed" heights="400">
 File:LO Calc 3 Processing the data .png|Inserting the formula

@@ Line 103: / Line 103: @@
 {{clear}}
-=== Navigating a spreadsheet ===
+==== Navigating a spreadsheet ====
 <gallery mode="packed" heights="350">
 File:Cal step 2.png|Navigation from various sheets
@@ Line 111: / Line 111: @@
 * Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns.  <br>
-=== Inserting a new sheet ===
+==== Inserting a new sheet ====
 <gallery mode="packed" heights="200">
 File:Insert a sheet.png|Inserting a new sheet
@@ Line 120: / Line 120: @@
 {{clear}}
-=== Formatting a spreadsheet ===
+==== Formatting a spreadsheet ====
 <gallery mode="packed" heights="350">
 File:LO Calc 6 Formatting numbers.png| Formatting in Calc
@@ Line 139: / Line 139: @@
 To Split a merged cell, right click on the merged cell and click "split cell".
-=== Freeze or Unfreeze rows and columns ===
+==== Freeze or Unfreeze rows and columns ====
 If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">
@@ Line 164: / Line 165: @@
 {{clear}}
-=== Sorting the data ===
+==== Sorting the data ====
 <gallery mode="packed" heights="320">
 File:LO_Calc_4_Sorting_data.png|Sorting the Data
@@ Line 173: / Line 174: @@
 {{clear}}
-=== Preparing charts and graphs===
+==== Preparing charts and graphs====
 <gallery mode="packed" heights="200px">
@@ Line 187: / Line 188: @@
 #In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".
-=== Working with Pivot tables ===
+==== Working with Pivot tables ====
 The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.
 <gallery mode="packed" heights="250">
@@ Line 212: / Line 213: @@
 {{Clear}}
-=== Print Preview ===
+==== Print Preview ====
 Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.
 [[File:LO Calc Margin.png|thumb|Setting the margin ]]
@@ Line 225: / Line 226: @@
 # Use "Format --> Page" option to insert header / footer information, such as file name, page number etc. <br>Use "Print preview" feature to keep checking if the formatting is satisfactory <br>
-=== Adding Page Header or Footer ===
+==== Adding Page Header or Footer ====
 <gallery mode="packed" heights="300">
 File:LO Calc Header Footer.png|Header/Footer option in Print Preview
@@ Line 233: / Line 234: @@
 {{clear}}
-=== Saving the files and formats ===
+==== Saving the files and formats ====
 # Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.
 # The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").
@@ Line 243: / Line 244: @@
 To do this, "File --> Export as PDF". A window appears which lets you to change the default settings. You can do the required changes and click "Export". In the next window it asks you to give the path where to export the file.
-== Advanced features ==
+==== Advanced features ====
 * Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books.
 * You can also generate multi-variate tables using the 'Pivot' feature.
@@ Line 252: / Line 253: @@
 * Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.
-==Ideas for resource creation==
+===Ideas for resource creation===
 # Calc can be used for analyzing data sets generated by your students as part of projects. Large secondary data sets can also be analyzed.  Some of these project ideas include information about family members, houses in the area, crops / vegetation in the area, goods sold and prices in local shop and programs of the local government and budgets etc. The collected information can be analyzed and published in tabular cum graph formats.
 # Spreadsheets are also useful for helping solving numeric puzzles by setting up formulas and extrapolating.
-==References==
+===References===
 #[https://en.wikipedia.org/wiki/LibreOffice_Calc Wikipedia]
 #[https://help.libreoffice.org/scalc/.uno:HelpIndex?Language=en-US&System=UNIX&Version=5.2 User manual for LO Calc]

@@ Line 87: / Line 87: @@
 If you are not able to install LibreOffice in your MAC machine, [https://www.libreoffice.org/get-help/install-howto/macos/ follow this official website installation instructions]
-==Working with the application==
+===Working with the application===
 # [https://teacher-network.in/OER/images/9/96/REDUCED_MINIMUM_-_Learning_spreadsheet_-_Bangalore_South_3_Block_Schools_Dise_data_2015-16_March_2018.ods Download this file] to practice on a simple sample data sheet.
 # [https://teacher-network.in/OER/images/1/1d/Bangalore_South_3_Block_Schools_Dise_data_2015-16_aided_September_2017.ods Download this file]  of additional sheets with analyses, reports etc.
-===Opening a spreadsheet===
+====Opening a spreadsheet====
 <gallery mode="packed" heights="350">
 File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface

@@ Line 111: / Line 111: @@
 * Columns and rows can be inserted or deleted or hidden in a spreadsheet. You can right click anywhere on the spreadsheet and insert/ delete rows and columns. You can also go to Sheet menu and insert rows/ columns.  <br>
-==== Inserting a new sheet ====
+=== Inserting a new sheet ===
 <gallery mode="packed" heights="200">
 File:Insert a sheet.png|Inserting a new sheet

@@ Line 157: / Line 157: @@
 * When the cursor is on this cell, the formula will be seen in the ‘formula’ bar on top of the sheet, below the menu.<br>All arithmetic operations, statistical operations are possible with spreadsheet.
-* You can ‘copy paste’ a formula from one cell to other cells in the same column, here ‘copy paste’ by default will copy paste the formula and not the content. This 'copy' and 'paste' of formula is not useful, when we want to 'fix' one value in our formula.
+* You can ‘copy paste’ a formula from one cell to other cells in the same column, here ‘copy paste’ by default will copy paste the formula and not the content. This 'copy' and 'paste' of formula is not useful, when you want to 'fix' one value in our formula.
-* For instance, if we are computing 'Percentage of total' in the example of Average annual rainfall (cms) then, You can input in column ''C2 "=B2*100/B16"''. If you copy this cell C2 to C3, Calc will change the formula to "''=B3*100/B17''", since it will increment both numerator and denominator cells.
+* For instance, if you are computing 'Percentage of total' in the example of Average annual rainfall (cms) then, You can input in column ''C2 "=B2*100/B16"''. If you copy this cell C2 to C3, Calc will change the formula to "''=B3*100/B17''", since it will increment both numerator and denominator cells.
 * However consider you want to fix the denominator to '''B16''<nowiki/>'. To 'fix' the reference, you should insert '$' before the cell reference. So you should give formula ''C2 "=B2*100/B$16''" since you want to fix the value in the 16th row. When you copy paste the formula to C3, it will copy as "''=B3*100/B$16''", which is what you want.
@@ Line 212: / Line 212: @@
 ==== Print Preview ====
-Before printing any document we must make sure about the overall preview of the page. So get that we can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.
+Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.
 [[File:LO Calc Margin.png|thumb|Setting the margin ]]
 * Click on margin icon for the flexible movement of margins in the spreadsheet.
@@ Line 233: / Line 233: @@
 ==== Saving the files and formats ====
-# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. We can name this file “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.
+# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.
 # The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").
 # Main difference between "Save" and "Save As" is that Save Saves the document whereas Save As saves the document with another name.

@@ Line 26: / Line 26: @@
 |The application on mobiles and tablets
 |[https://play.google.com/store/apps/details?id=com.onlyoffice.documents&hl=en_IN&gl=US OnlyOffice for Android]
 |-
 |Development and community help

@@ Line 244: / Line 244: @@
 * Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books.
 * You can also generate multi-variate tables using the 'Pivot' feature.
-* The 'functions' in Calc are many and can meet statistical, mathematical functions which can be useful for exploring topics in Mathematics and Statistics.
+* The 'functions' in Calc are many and can meet statistical, logical, textual, mathematical functions which can be useful for exploring topics in Mathematics and Statistics.
 * You can use Calc to store contact information, which can be used along with the Thunderbird email client, to generate customized mass email messages (this functionality is called 'mail merge').
-* Variety of user defined formulae can be added such as Statistical, Logical, Arithmetic operations.
+* User defined formulae can be created and added to make the application more relatable.
 * You can repeat the column or row headings automatically across printed  pages (hint – define print area). You can refer the references section for learning these advanced features.
 * Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.

@@ Line 4: / Line 4: @@
 {{Template:Book-sidebar}}
 === Introduction ===
-Earlier accountants used large pieces of paper to record business finances, to enter information like costs, payments, taxes, income etc. so that they got a complete financial overview.  These large paper pieces were called “spreadsheets”. The digital spreadsheet is similar, with columns and rows. A cell is a combination or intersection of a row and a column, in which information both text and numeric can be input. A sheet can be simply understood as an array of cells. Altogether Spreadsheets are useful for capturing and analyzing data.
+The spreadsheet is a sheet with a collection of columns and rows. It contains number of cells. A cell is a combination or intersection of a row and a column, in which information both text and numeric can be input. A sheet can be simply understood as an array of cells. Altogether Spreadsheets are useful for capturing and analyzing data.
 ==== Basic information ====