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
   195   196   197   198   199   200   201   202   203   204   205