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

