Page 41 - TP_Plus_v4_Class6
P. 41

ORDER OF OPERATION


                 When 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. It 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.


                      UNDERSTANDING CELL RANGE


                 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 a 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.

                 Selecting a Range in a Worksheet

                 Perform the following steps to select a range by using the mouse:



                                                                                              Hintbot
                                       Click on the first cell from which   1
                                       you want to start the range.                 To select a range: Click
                                                                                     on the first cell. Press
                                                                                     and hold the Shift key
                                                                                    and click on the last cell
                                                                                   up to which you want to
                                                                                      make the selection.



                                             Press and hold the left mouse button and drag    2
                                             the mouse diagonally to select the desired range.


                 Release the mouse button on the cell up to which you want to select the range.

                 Naming a Cell Range

                 Excel allows us to assign a name to a cell range. This name can be used in place of cell address in
                 formulas to make the formulas easier. Perform the following steps to assign a name to a cell range:






                                                                               #Charts, Formulas and Functions in Excel  39
   36   37   38   39   40   41   42   43   44   45   46