Page 216 - CA_165_V2.0_C9_Flipbook
P. 216

21 st
                                                    Lab Assignment ‘n Activity                Century   #Technology Literacy
                                                                                                Skills


                     Complete the following activities and tick on the circle:
                     ª  Consider the given worksheet:
                           What will be the value displayed in cell B5 after evaluation?

                           If the formula of the cell B5 is copied to C5, then what will be the resultant formula?














                     Complete the following activities and tick on the circle:
                     ª   What will be the value displayed in cell H2 after evaluation?
                     ª   If the formula of the cell H2 is copied to H3 to H6, what will be the resultant
                         formula in all cells?

















                  Mixed Referencing

                  This type of cell referencing is the combination of absolute and relative referencing. While applying
                  mixed referencing, either the row number or the column name of the cell address in the formula is

                  fixed. The cell references such as $F5 or F$5 are examples of mixed referencing. $F5 means that the
                  column F is absolute and row 5 is relative while F$5 means that the column F is relative and row 5 is
                  absolute.

                  Consider the given worksheet:

                  Assume  that  the  formula  of  cell  I3  is =H3/$B$1*100  and  hence  when  copied  to  I4,  it  changes  to
                  =H4/$B$1*100. As it is mixed cell referencing, only the relative part of it gets updated and the rest
                  remains absolute. To apply mixed reference:

                  l    Type the formula in I3 cell and put $ sign before column name of the address.







                   214   Touchpad Computer Applications (Ver. 2.0)-IX
   211   212   213   214   215   216   217   218   219   220   221