Page 44 - TP_Modular_V2.1_Class7
P. 44

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.

                      ORDER OF OPERATION

                  While performing calculations using a formula, Excel follows certain rules of precedence:
                      Excel calculates expressions within parentheses ‘(‘ , ’)’ first.

                      Excel calculates multiplication and division before addition and subtraction.
                      Excel calculates consecutive operators with the same level of precedence from left to right.
                  For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel multiplies 10 by 2 and then
                  adds 10.

                  However, the formula =(10 + 10)*2 produces a result of 40. This is because Excel calculates the
                  expression (10 + 10) within the parentheses first and then multiplies by 2.
                  If you are unsure of the order in which Excel calculates, use parentheses even if the parentheses
                  aren’t necessary. Parentheses also make your formulas easier to read.

                      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, formula is directly typed in the cell after
                     typing an equal to sign. After entering the formula in the cell, press the Enter key. When the

                     Enter key is pressed, the result of formula appears in the cell.








                                            Formula in cell                      Output
                       Typing the formula in the Formula bar: In this way, we can type the formula in Formula bar
                     after selecting the cell as follows:
                        After entering the formula, when we press the Enter key, the
                     result will appear in the selected cell.

                      UNDERSTANDING CELL RANGE                                                Formula in Formula bar


                  A group of selected cells is called a range. The selected cells should be in continuation to form
                  a range. When a range is selected in a worksheet, a rectangular shape is formed. We can use
                  cell range to perform a calculation on multiple cells. The address of a range is created by using
                  the starting and the ending cell addresses separated by a colon (:) sign. For example, if we have
                  selected the cells from B2 to E3 then the address of the range will be B2:E3.


                   42       Modular (Ver. 2.1)-VII
   39   40   41   42   43   44   45   46   47   48   49