Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - 2620_Birla Open Mind C-6
P. 45

    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  43

| 40 41 42 43 44 45 46 47 48 49 50 |