Page 20 - iprime_V2.2_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: To do this, type the formula directly into the cell
                     after typing an equal sign (=). For example:



















                                                              Formula in Cell
                    After entering the formula in the cell, press the
                     Enter key. When you press Enter, the result of
                     the formula will appear in the cell:
                      Typing the Formula in the Formula Bar: In this
                     method, you type the formula in the Formula
                                                                                             Output
                     Bar after selecting the cell. For example:

























                                                           Formula in Formula Bar
                    After entering the formula, press the Enter key. The result will then appear in the selected
                     cell.

                      CELL REFERENCING IN FORMULAS AND ITS TYPES

                  A cell reference is an address used in a formula to denote a specific cell. A formula may contain
                  references to other cells, meaning the result of the formula depends on the values in these
                  referenced cells. If you change any of the values in the referenced cells, the result of the formula
                  will update automatically.


                  18     iPRIME (Ver. 2.2)–VIII
   15   16   17   18   19   20   21   22   23   24   25