Page 97 - IT-802_class_12
P. 97

Drag



                                                                  The formula containing
                                                                   the cell addresses








            3.12.2 Absolute Referencing

            Absolute referencing enables us to apply a formula in which the address of the cell does not change even if the formula
            is applied to the new location of the cell. To apply an absolute cell reference, a $ (dollar) sign is added before the row
            number and/or column name in the cell address (i.e., the $sign fixes the value).

            To apply a formula by absolute referencing:

             1   Type the formula in the original cell and put a $ sign before the row number and/or column ‘name of the address’.
             2   Drag the Auto Fill Handle tool over the cell where the formula is to be applied.
                 [OR]

                 Right-click the mouse over the cell containing the formula and click on the Copy option.
             3   Move to the new cell, right-click the mouse, and click on Paste.

            For example, Let us assume that the formula applied in cell G3 is =C3+D3+E3+F3. Now to apply the same formula with the
            value of the same cell, put the $ sign before Row and Column no. Now cell G3 contains formula =$C$3+$D$3+$E$3+$F$3.
            After applied to another Cell G5, the addresses of the Cell, which form the expression do not change. The Formula in

            Cell G5 will remain as it is, i.e., the formula as applied in G3.
            Thus it displays the same result/data as displayed in G3.









                                                                          The cell addresses
                                                                           will not change
                                                                          when the formula
                                                                             is copied to
                                                                             another cell











                                                                                                   ICT Skills-IV  95
   92   93   94   95   96   97   98   99   100   101   102