Page 284 - Trackpad IT-402_Class-IX
P. 284

Autofill Using Fill Handle for Copying the Formula
        Autofill can also be used to copy a formula to a continuous range of cells. It saves the time and effort of writing long
        and complex formulae again and again. Moreover, it reduces the chances of making errors too. Perform the following
        steps to do so:
        Step 1:  Create a worksheet with the marks of English and Maths of 10 students as shown below.


















        Step 2:  Write the sum formula in cell E3 to add the contents of cells C3 and D3.

        Step 3:  Press Enter key.
        Step 4:   Now click and hold the left mouse button and drag the fill handle down till cell E12. You will see that the
                formula is automatically copied to the rest of the cells with the cell address automatically adjusted accordingly
                as shown below.























                                Complete the following spreadsheet. Use Fill Handle wherever possible to automate the
                 uiz Bee        date entry. F2 should be the sum of the values from B2 to E2. Drag the Fill Handle to copy
                                this formula till F6. Total should appear from  G2 to G6.
                                H2 should be the average of the values from B2 to E2. Copy this formula till H6 using the
                                Auto Fill feature.




















          284   Trackpad Information Technology-IX
   279   280   281   282   283   284   285   286   287   288   289