Page 71 - iPro_trackGPT_V5_Class7
P. 71

What if you could use Excel to track the books you’ve read and the books you
                                   want to read? How would you rate them and what genres would you include?



                    AUTO FILL

                 The Auto Fill feature in Excel allows you to quickly fill cells with repetitive or sequential data
                 by dragging the fill handle, a small square at the bottom-right of a cell. It can extend patterns,

                 series, and custom lists, or copy formatting as needed. To use the Auto Fill feature, follow the
                 given steps:





                       1  Enter the first two numbers and
                      select both the cells containing the
                      numbers you have entered.
                                                                                     2  Position the mouse pointer
                                                                                    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


                 In Excel, formulas start with an equal sign (=). When a cell content begins with this sign, Excel
                 recognises it as a formula. If you omit the equal sign, Excel will treat the entry as text and the
                 calculation will not work.
                 Using formulas in Excel to perform calculations involves  entering  expressions  that perform
                 mathematical operations on cell values.

                 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



                                                                                         More on Spreadsheets    69
   66   67   68   69   70   71   72   73   74   75   76