Page 27 - Digicode_AI_class_6
P. 27
Cell Referencing in Formulas and its types
A cell reference is a cell address that can be used in a formula to denote a specific cell. A formula
may contain references to other cells. In such a case, the result of a formula depends on the values
in the referenced cells. If you make any changes in the referenced cells, the result will be changed
automatically.
To see how this works:
• Enter 10 in cell A1.
• Now click on cell A2.
• Type =A1*2 in the formula bar.
• Press the ENTER key.
The value in cell A2 is 20.
If you change the value in cell A1 from 10 to any value, the value in cell A2
will also change.
Cell references are especially helpful when you create complex formulas.
There are three types of cell references used in Excel: relative, absolute, and mixed.
Relative References
By default, a cell reference is a relative reference. In relative reference, reference changes according
to the location of the cell. When a formula that possesses a relative reference is copied from one cell
to another cell, the value in the copied cell also changes.
To use the relative cell reference, follow the given steps:
2 Click on the Copy command.
3 Select another
cell in which you
want to copy the
formula and click
on the Paste
command.
1 Select the cell that contains the formula in
which the reference of other cells is used.
Formulas and Functions in Excel 25

