Page 20 - TP_iPlus_V2.1_Class8
P. 20

i +   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, press the Enter key. When the Enter key is pressed, 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.

                   i +   CELL REFERENCING IN FORMULAS AND ITS TYPES

                  A cell reference refers to a cell or a range of cells on a worksheet that can be used to find the
                  values or data. The main benefit of using a cell reference is when the data present in referenced
                  cell(s)  in another  worksheet  changes,  a  value  returned  by  the  cell reference  is automatically
                  updated.

                  Cell Reference refers to:
                  •  Data from one or more contiguous cells on the worksheet



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