Changes

You can do almost any kind of computation or processing with a spreadsheet.   

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 “∑” where you will get various options like SUM, AVERAGE, MIN, MAX.  Choose SUM here and hit "Enter" and the application will insert the same formula.   

For example, here you can 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 an "=" sign. Or you can simply use the shorthand icon on the menu bar “∑” where you will get various options like SUM, AVERAGE, MIN, MAX.  Choose "SUM" here and hit "Enter" and the application will insert the same formula.   

{{Clear}}

{{Clear}}

<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 we will input in column C2 "=B2*100/B16". If we 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 we want to fix the denominator to 'B16'. To 'fix' the reference, you should insert '$' before the cell reference. So you should give formula C2 "=B2*100/B$16" since we 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.  

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