Page 75 - iPrime_V2.2_class7
P. 75

Step 3  Position the mouse pointer over the bottom right corner of the last selected cell. The

                         pointer changes to (+) sign.
                 Step 4  Drag the mouse pointer over the cells you want to include in the series.


















                                                             Using AutoFill
                 The cells display the number series automatically.


















                                                        Series after using AutoFill
                     USING FORMULAS TO PERFORM CALCULATION


                 Formulas in Excel begin with an equal to (=) sign. When the contents of a cell begin with an equal
                 to (=) sign, Excel understands that the user has given a formula. If you don’t enter the equal sign,
                 Excel will treat your entry as text and fail the calculation.
                 To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1.
                 Then type = 5 + 5, and press Enter key. As you press the Enter key, Excel performs the calculation
                 and display 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
                 Clickipedia



                   Excel follows 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.




                                                                                         More on Spreadsheets      73
   70   71   72   73   74   75   76   77   78   79   80