Page 27 - Digicode_AI_class_6
P. 27

Cell Referencing in Formulas and its types

            A cell reference is a cell address that can be used in a formula to denote a specific cell. A formula
            may contain references to other cells. In such a case, the result of a formula depends on the values
            in the referenced cells. If you make any changes in the referenced cells, the result will be changed
            automatically.
            To see how this works:

               • Enter 10 in cell A1.
               • Now click on cell A2.
               • Type =A1*2 in the formula bar.

               • Press the ENTER key.

            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

            will also change.
            Cell references are especially helpful when you create complex formulas.

            There are three types of cell references used in Excel: relative, absolute, and mixed.

            Relative References

            By default, a cell reference is a relative reference. In relative reference, reference changes according

            to the location of the cell. When a formula that possesses a relative reference is copied from one cell
            to another cell, the value 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
                                                    which the reference of other cells is used.



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