Page 201 - CA 165 ver 1.0 Class 9
P. 201
Absolute Referencing
It is applied when a user does not want to change the value while copying the formula with cell address
to another cell. To apply an absolute cell reference, a ‘$’ (dollar) sign is prefixed before the row number
and/or the column name in the cell address. (i.e. $ sign fixes the value).
In the given worksheet; the maximum marks of each subject i.e. English, Maths and Science is 100
as entered in the cells C3, D3, E3 respectively. To find total of max. marks, let’s apply the formula
‘=$C$3+$D$3+$E$3’ in the cell F6; whose computed value will be 300.
To apply absolute reference to other cells i.e., F7 to F10: Drag the ‘AutoFill Handle Tool’ over the cells F7
to F10 where the formula is to be applied.
Formula in the
cells will be
=$C$3+$D$3+$E$3
=$C$3+$D$3+$E$3
=$C$3+$D$3+$E$3
=$C$3+$D$3+$E$3
When the formula is copied to other cell i.e. F7 to F10, the absolute reference i.e. the formula with
address of the cell will not change and value remain as 300 which will be automatically displayed in
respective cells.
Data Analysis 199

