Page 41 - Plus V4 with Adobe class 6
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. 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