Page 198 - CA 165 ver 1.0 Class 9
P. 198
In a worksheet, a formula is written in a particular cell that displays result after calculation. The formula
is applied on a range of multiple cells. In ‘Calc’, a formula works only if it is written with ‘=’ as a prefix
sign. The formula typed in a cell can be seen in the formula bar.
In ‘Calc’, formula can be categorized as:
FORMULA
Formula with Cell Formula with Formula with
addresses Cell names in-built functions
Formula With Cell Addresses
Each cell in the worksheet has a unique address that is formed by the intersection of its Column and
Row, for example, ‘A10’. Here, ‘A’ is the Column name and ‘10’ is the Row number.
Calculations are performed on cells on the basis of Cell Addresses mentioned, while writing the
formula. The formula thus applied displays the result of the calculations done on the data stored in the
mentioned cell addresses.
Suppose, the data entered in cells A1, A2, A3 and A4 are 5, 15, 20 and 60 respectively. In cell A5, a
formula is entered to calculate the sum of these numbers as follows: ‘=A1+A2+A3+A4’.
Here, the output will be 100 and would be displayed in the cell A5, as soon as the ‘Enter’ key is pressed.
Now in the next cell, i.e. A6, enter a new formula to find the average of cell values as ‘=A5/4’. Now the
output, 25 will be displayed in the cell (A6).
The significant factor of using a formula in spreadsheet 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 formula is also recalculated.
In the above example, if the entry in cell A1 is changed from 5 to 25, then cell A5 will change from 100
to 120 and the value of A6 will change, i.e., from 25 to 30.
Notes
In Worksheet, a range of cells, is represented using a colon between the address of first cell and the
last cell, i.e., say for denoting a range of cell from A1 to A5 we will write ’A1 : A5’.
Formula With Cell Names
In ‘Calc’, Formula can be applied in reference to cell names. For doing so, first define the name of the
cell or the range of cells.
For naming a cell, click on the cell and type the name for that cell in the name box, and press Enter.
Name can be used directly in a formula.
196 Touchpad Computer Applications-IX

