Page 96 - IT-802_class_12
P. 96
The formula will be copied and the result will be seen.
3.12 CEll AND RANGE REfERENCES
A rectangular box formed by the intersection of a row and a column is called a cell. A cell is the basic unit of a worksheet
where data (numbers, text, formulas, etc.) are entered.
Range Referencing is the way to refer the formula or function of one cell to another cell along with the row or column.
There are three types of Cell and Range Referencing in Calc.
Ð ÐRelative Referencing
Ð ÐAbsolute Referencing
Ð ÐMixed Referencing
3.12.1 Relative Referencing
In relative referencing, the same formula is applied to the new cell, but the value of data is taken as per the new cell
address; i.e., the formula does not change, but values may change with the change in address.
For example, let us assume that the formula in cell G2 is =B2+C2+D2+E2+F2 and it is to be applied to another cell, i.e.,
G5. Here, the new expression of the formula gets changed in accordance with the change in position of the cell, i.e.,
the formula in cell G5 will become =B5+C5+D5+E5+F5.
To apply a formula by relative referencing:
1 Right-click on the cell and select the option Copy.
2 Move to the cell where the formula is to be applied.
3 Right-click on the cell and select the option Paste.
[OR]
Drag the Auto Fill Handle tool from the cell that contains the formula over the cells where the formula has to be
applied.
94 Touchpad Information Technology-XII

