1,325
edits
Changes
Jump to navigation
Jump to search
Line 94:
Line 94: − + + + + + Line 102:
Line 106: − + + + Line 149:
Line 155: − <br>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. <br>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. 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. 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.+ + + +
→Opening a spreadsheet
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
</gallery>
</gallery>
* LibreOffice Calc can be opened from "Applications --> Office --> LibreOffice Calc". This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application, it will show a window like this. The spreadsheet consists of rows and columns. Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter. <br>Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall. <br>You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type CTRL+B) to make the headings bold.
* LibreOffice Calc can be opened from "Applications --> Office --> LibreOffice Calc". This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application, it will show the window like as mentioned in the image above (Basic spreadsheet interface). The spreadsheet consists of rows and columns. Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter.
* Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall.
* You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type Ctrl+B) to make the headings bold.
Like in the case of text document, you can use the File menu to save your spreadsheet. The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.
Like in the case of text document, you can use the File menu to save your spreadsheet. The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.
{{clear}}
{{clear}}
File:Cal step 2.png|Navigation from various sheets
File:Cal step 2.png|Navigation from various sheets
</gallery>
</gallery>
* You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using "Ctrl" Key, such as Ctrl+Home (go to Cell A1), Ctrl+End (bottom rightmost part of filled cells / entered data), Ctrl + Up Arrow (next cell in same column, before an empty cell) etc. <br>It is useful to become comfortable using keyboard to move across the spreadsheet.<br>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>
* You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using "Ctrl" Key, such as Ctrl+Home (go to Cell A1), Ctrl+End (bottom rightmost part of filled cells / entered data), Ctrl + Up Arrow (next cell in same column, before an empty cell) etc.
* It is useful to become comfortable using keyboard to move across the spreadsheet.
* 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 ====
{{Clear}}
{{Clear}}
* 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.
* 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.
* 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.
{{clear}}
{{clear}}