Page 78 - iPlus_Ver_2.0_class_7
P. 78

i +   USING FORMULAS TO PERFORM CALCULATION

                  Functions are in-built formula in Excel which can be used to perform  arithmetic and non-
                  arithmetic task. In Excel, there are more than 400 in-built functions which can be applied directly
                  or as part of a formula. A function contains ‘Name’ & ‘Argument’.

                  For Example: A formula, say as A6=A1+A2+A3+A4+A5 can be written using the ‘SUM’ function
                  along with cell range as: A6=SUM(A1:A5)
                  ‘Name’ is the name of function that signifies the nature of operation. ‘Argument’ specifies the
                  values or the range of cells on which the specific operation is being applied and is always enclosed
                  within the opening and closing parenthesis (i.e. Name refers to the operator and Argument
                  refers to the operand).

                  To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1.
                  Then type = 5 + 5, and press the Enter key. After you press the Enter key, Excel performs the
                  calculation and produces the result as 10 in cell A1.

                  Enter some more formulas in other cells and see what results are shown by Excel.
                      1. =8 – 5                 2. =8 * 5                  3. =8/5                 4. =8 ^ 5
                    The results will be 3, 40, 1.6, and 32768, respectively.

                  Some formulas based on the BEDMAS rule can be entered as:
                      1. =(8 + 5) – (2 + 3) ^ 2             2. =(9/3) * (4 ^ 2) – 5

                     Info Byte

                      Excel follows the BEDMAS rule for doing mathematical calculations, where B stands for
                      Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition, and S
                      for Subtraction.

                  You can also use cell addresses to perform calculations in the following way:









                  Notice that when cell C1 is selected, the Formula bar shows the formula you just typed. You can
                  also calculate the sum of adjacent cells by pressing the Alt+= keys together after selecting the
                  cells.
                  •  What appears in the cell is the result.

                  •  What appears in the formula bar is the value, which is a formula in this case.

                  The elements of a formula are:
                  •  References: A cell or a range of cells that you want to use in your calculation.

                  •  Operators: Symbols (+, -, *, /, ^, $, %, etc.) that specify the calculations to be performed.
                  •  Constants: Numbers or text values that do not change.




                    76
                         iPlus (Ver. 2.0)-VII
   73   74   75   76   77   78   79   80   81   82   83