1,325
edits
Changes
Jump to navigation
Jump to search
Line 134:
Line 134: − + + + Line 148:
Line 150: − +
→Inserting formulae for computations
File:LO Calc 3 Processing the data Summing up rainfall information.png|Inserting Formulae
File:LO Calc 3 Processing the data Summing up rainfall information.png|Inserting Formulae
</gallery>
</gallery>
You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
You can do almost any kind of computation or processing with a spreadsheet.
For example, here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
{{Clear}}
{{Clear}}
You can sort the data in anyway you want. You could sort it on the descending order of the rainfall (Column B) to see the data by the cities with the heaviest rainfall at the top. You can sort the data by cities (Column B).
You can sort the data in anyway you want. You could sort it on the descending order of the rainfall (Column B) to see the data by the cities with the heaviest rainfall at the top. You can sort the data by cities (Column B).
{{Note}} You should select the entire sheet ("Edit --> Select All", or simply CTRL-A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.
{{Note}} You should select the entire sheet ("Edit --> Select All", or simply Ctrl+ A) or keep the cursor on a single cell, else you may sort only the data selected which will be incorrect.
{{clear}}
{{clear}}