Page 27 - Computer Genius Class 06
P. 27
Cell Referencing in Formulas and its types
cell re erence is a cell address that can e used in a ormula to denote a specific cell. ormula
may contain re erences to other cells. n such a case the result o a ormula depends on the alues
in the re erenced cells. you ma e any changes in the re erenced cells the result ill e changed
automatically.
To see how this works:
Enter 10 in cell A1.
Now click on cell A2.
Type =A1*2 in the ormula ar.
Press the ENTER ey.
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
ill also change.
ell re erences are especially help ul hen you create comple ormulas.
There are three types o cell re erences used in cel relati e a solute and mi ed.
Relative References
y de ault a cell re erence is a relati e re erence. n relati e re erence re erence changes according
to the location o the cell. When a formula that possesses a relative reference is copied from one cell
to another cell the alue 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
hich the re erence o other cells is used.
Formulas and Functions in Excel 25

