Changes

==== Inserting formulae for computations====

==== Inserting formulae for computations====

[[File:LO Calc 3 Processing the data Summing up rainfall information.png|800x800px|left]]

File:LO Calc 3 Processing the data Summing up rainfall information.png|Inserting Formulae

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. 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}}

==== Sorting the data ====

==== Sorting the data ====

[[File:LO_Calc_4_Sorting_data.png|800x800px|left]]  

[[File:LO_Calc_4_Sorting_data.png|800x800px|left]]