Page 20 - iPro_trackGPT_V5_Class8
P. 20

After typing the formula into the cell, press the Enter key. Then, the cell will display the result
                     of the formula.












                     Enter the Formula  in the Formula  Bar: Start  by clicking on the Formula bar  above the
                     worksheet,  then type an equal sign  (=) followed by the formula. This  method allows the
                     formula to be entered and edited outside the cell.















                     After typing the formula into the cell, press the Enter key. Then, the cell will display the result
                     of the formula.
                     CELL REFERENCING IN FORMULAS AND ITS TYPES

                  A cell reference is the address of a cell that you can use in a formula to show a specific cell. A
                  formula might also use other cell references. The formula's result depends on the values in those
                  cells. If you change the values in the referenced cells, the formula's result will automatically
                  change.

                  To see how this works, follow the given steps:

                                1  Enter 10
                               in cell A1.                                                3  Type =A1*2
                                                                                         in the Formula
                                                                                         bar and press the
                                2  Click on                                              Enter key.
                                cell A2.


                  If you change the value in cell A1, the value in cell A2 will change as well.
                  Cell  references make it easier to work with formulas, especially  for
                  complex ones. Excel uses three types of cell references: Relative, Absolute,
                  and Mixed.




                    18    TrackGPT iPRO (V5.0)-VIII
   15   16   17   18   19   20   21   22   23   24   25