Page 31 - Plus_V2.2_C6_Flipbook
P. 31

Step 4:   Drag the mouse pointer over the cells you want to include in the series. The cells display the
                         number series automatically.





















                                                        Series after using AutoFill


                  Let’s PraCtiCe                                                                     Subject Enrichment


                   Create an Excel worksheet having a list of months and expenditure in each month. Use the
                   Autofill to fill the names of months.












                        USING FORMULAS TO PERFORM CALCULATION

                 Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with equal to sign,
                 Excel understands that user has given a formula here. If you don’t enter the equal sign, Excel will treat
                 your entry as text and the calculation will fail.
                 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
                 produces the result as 10 in cell A1.
                 Enter some more formula 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 BEDMAS rule can be entered as:
                     1.  =(8 + 5) - (2 + 3)^ 2             2.  =(9/3) * (4 ^ 2) - 5


                                                             Tech Fact

                   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 Excel 2016   29
   26   27   28   29   30   31   32   33   34   35   36