Page 20 - Trackpad_ipro 4.1_Class8
P. 20

DIFFERENT WAYS TO ENTER FORMULAS

                  There are mainly two ways to enter a formula in a worksheet:
                      Typing the formula directly in the cell: In this way, the formula is directly typed in the cell
                     after typing an equal sign as follows:


















                     After  entering  the  formula  in the  cell, when  we
                     press the Enter key, the result of the formula will
                     appear in the cell:

                      Typing the formula in the Formula bar: In this way, we can type the formula in the Formula
                     bar as follows:




















                     After entering the formula, when we press the Enter key on the keyboard, the result will
                     appear.

                      CELL REFERENCING IN FORMULAS AND ITS TYPES

                  A cell reference is the address of a specific cell or range of cells used in a formula to indicate
                  where to retrieve data from. If a formula contains references to other cells, Excel will automatically
                  update the result based on changes in the referenced cells.

                  To see how this works:
                  Step 1  Enter 10 in cell A1.
                  Step 2  Now click on cell A2.

                  Step 3  Type =A1*2 in the Formula bar.
                  Step 4  Press the Enter key.





                    18     iPro (Ver. 4.1)-VIII
   15   16   17   18   19   20   21   22   23   24   25