Page 75 - Trackpad_ipro 4.1_Class7
P. 75

AUTOFILL

                 AutoFill feature  automatically fills  a series of data  in your  worksheet.  It saves your  time by
                 completing the text or number series for you. To use the Autofill feature, follow the given steps:


                                                                                 1  Enter the first two numbers and
                                                                                 select both the cells containing the
                      2  Position the mouse pointer                              numbers you have entered.
                     over the bottom right corner of
                     the last selected cell.














                                                        3  Drag the mouse pointer over
                                                       the cells you want to include in
                                                       the series.



                     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 the Enter key. After 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 the 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.

                 You can also use cell addresses to perform calculations in the following way:













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