Page 215 - CA_165_V2.0_C9_Flipbook
P. 215
In the given worksheet; the maximum marks of each subject i.e., English, Hindi, Maths, Science, Computer,
and Social Science is 100 as entered in the cells C3, D3, E3, F3, G3, H3, respectively. To find total of max.
marks, let’s apply the formula =$C$2+$D$2+$E$2+$F$2+$G$2+$H$2 in the cell F6; whose computed
value will be 600.
To apply absolute reference to other cells i.e., I5 to I8: Drag the AutoFill Handle tool over the cells I5
to I8 where the formula is to be applied.
Formula in the
cells will be =$C$2+$D$2+$E$2+$F$2+$G$2+$H$2
When the formula is copied to other cells i.e., I5 to I8, the absolute reference i.e., the formula with
address of the cell will not change and value will remain as 600 which will be automatically displayed
in respective cells.
Data Analysis 213

