Page 317 - TP_IT_V1.0_C9_flipbpookl
P. 317
Now let us do another example. Consider the following spreadsheet and perform the given tasks:
• Select cell A2. Drag it till A11 using Fill Handle. You will get the Dates, automatically increased by 1.
• Select cell B2. Drag it till B11 using Fill Handle. You will get a list of Months.
• Select cell C2. Drag it till C11 using Fill Handle. You will get a list of Days of the week.
• Select cell D2. Drag it till D11 using Fill Handle. You will get the Serial numbers automatically increased by 1.
• Select cells E2 and E3. Drag them till E11 using Fill Handle. You will get a list of Odd numbers.
• Select cells F2 and F3. Drag them till F11 using Fill Handle. You will get a list of Even numbers.
After performing the above actions, the spreadsheet will look like as follows:
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 sheet 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 the Enter key.
Step 4: Select the cell E3.
Step 5: Click and hold the left mouse button and drag the fill handle down till cell E12.
Electronic Spreadsheet 315

