Page 251 - IT_Play_V1.0 Class9
P. 251
UNIT-4 ELECTRONIC SPREADSHEET
4 UNDERSTAND AND APPLY
REFERENCING
Cell referencing in LibreOffice Calc is a method used to link the formula or function in one cell to
another cell along the row or column. This allows users to apply formulas efficiently across multiple
cells. There are three types of cell referencing in LibreOffice Calc: Relative Referencing, Absolute
Referencing, and Mixed Referencing. Each type serves a different purpose, providing flexibility in how
formulas are applied and adjusted within a spreadsheet. Additionally, users can create and use custom
lists to further enhance data management and organisation.
CELL REFERENCING
Referencing is the way to refer the formula or function of one cell to other cell along the row or column.
There are three types of cell referencing in ‘LibreOffice Calc’.
Relative Referencing Absolute Referencing Mixed Referencing
RELATIVE REFERENCING
Relative referencing is the default type of referencing in LibreOffice Calc. It means that when you copy a
formula from one cell to another, the cell references in the formula change according to their relative position.
In simple words, relative referencing adjusts the cell reference based on where the formula is copied. For
example, a formula in the cell D2 is ‘=A2*B2-C2’ and it is to be applied to other cells i.e. D5. Here, the new
expression of the formula gets changed under the change in position of the cell, i.e. the formula in the cell
G5 will become as =A5+B5*C5.
ABSOLUTE REFERENCING
Absolute referencing is a way to keep a specific cell reference fixed, no matter where you copy the formula.
This means that when you copy a formula with an absolute reference to another cell, the reference does not
change.
In simple words, you can fix the row and column of a cell by using a dollar sign ($) before both the column
letter and the row number.
Understand and Apply Referencing 249

