Page 200 - CA 165 ver 1.0 Class 9
P. 200
Consider the worksheet:
Let us compute and find the total marks of the three subjects of student ‘Kavya’ in the cell F5, so the
formula in cell F5 is ‘=C5+D5+E5’.
Thus, to compute the total marks of other students, the new expression of formula will change according
to the change in position of the cell in consideration i.e. for computing total marks of Pooja, the formula
in the cell F6 will be ‘=C6+D6+E6’, and so on. To apply formula with respect to Relative referencing:
Step 1: Click on the cell where formula has been typed.
Step 2: Drag down the ‘AutoFill Tool’ of the cell which contains the formula over the new cells where
the formula has to be applied.
Formula in the
cells will be
=C6+D6+E6
=C7+D7+E7
=C8+D8+E8
=C9+D9+E9
Drag
AutoFill
Handle
The total marks of other students will be displayed in the cells respectively.
198 Touchpad Computer Applications-IX

