Page 87 - IT-802_class_12
P. 87
(It can be seen here that in F1, the formula is applied with respect to the address of the cell, i.e., E1).
The significant factor of using formulas in spreadsheets with cell addresses is that if a value or entry of one cell is
changed, then the values of all subsequent cells where the particular cell address has been applied with the formula
are also recalculated.
Formula with Cell Names
In Calc, a formula can be applied in reference to cell names. To do so, first define the name of the cell or the range of
cells.
For naming a cell, click on the cell and type a particular name for that cell in the address to replace the cell address
(co-ordinates) with the name and press the Enter key. A name can be used directly in a formula.
Perform the following steps to change the names of the cells:
1 Enter the given data in a worksheet.
2 Select the cell B2 and change its name in the Name Box. In this case, we have changed the S2019.
3 Similarly, change the names of cells C2 and D2 as S2020 and S2021 respectively.
ICT Skills-IV 85

