Page 27 - Computer Genius Class 06
P. 27

Cell Referencing in Formulas and its types

                   cell re erence is a cell address that can  e used in a  ormula to denote a specific cell.    ormula
                 may contain re erences to other cells.  n such a case  the result o  a  ormula depends on the  alues
                 in the re erenced cells.    you ma e any changes in the re erenced cells  the result  ill  e changed
                 automatically.

                 To see how this works:

                   Enter 10 in cell A1.
                   Now click on cell A2.

                   Type =A1*2 in the  ormula  ar.

                   Press the ENTER  ey.
                   The value in cell A2 is 20.

                 If you change the value in cell A1 from 10 to any value, the value in cell A2
                  ill also change.

                  ell re erences are especially help ul  hen you create comple   ormulas.
                 There are three types o  cell re erences used in   cel  relati e  a solute  and mi ed.


                 Relative References

                  y de ault  a cell re erence is a relati e re erence.  n relati e re erence  re erence changes according
                 to the location o  the cell. When a formula that possesses a relative reference is copied from one cell
                 to another cell  the  alue in the copied cell also changes.

                 To use the relative cell reference, follow the given steps:


                                                         2  Click on the Copy command.




                             3  Select another
                             cell  in  which  you
                             want to copy the
                             formula and click
                             on   the  Paste
                             command.












                                                         1  Select the cell that  contains the  formula  in
                                                         hich the re erence o  other cells is used.



                                                                              Formulas and Functions in Excel  25
   22   23   24   25   26   27   28   29   30   31   32