Changes

{{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, 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.  

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

{{clear}}

{{clear}}