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