Before we continue with Practice Exercise 8, let’s take a quick look at how the Autofill feature works. After you have summed one column and have more adjacent columns to sum, you do not have to sum each of these additional columns. Use the AutoFill feature to automatically sum these remaining columns.
Steps for performing an AutoFill:
Steps for performing an AutoFill:
- After summing one column, make the cell with the column total the active cell. Since the column total for the example below is in cell A4, make cell A4 the active cell.
- Move the mouse cursor to the bottom-right corner of the cell with the column total, which is cell A4 in the example below.
- When the mouse cursor changes into a thin black cross, stop moving the mouse. This black cross is known as the fill handle and is used to perform the AutoFill. In the graphic shown below, that cell is cell address A4.
Practice Exercise 8: The AutoFill Feature
FIGURE 1
FIGURE 2
FIGURE 3
STEP 3A: Using the AutoFill Feature (FIGURE 4)
Make cell B5 the active cell. Move mouse cursor down to lower right corner of cell B5. You should see the mouse cursor change its symbol to a thin black cross. The AutoFill symbol is a thin black cross. It is referred to as the “fill handle.” STEP 3B: The graphic shows this thin cross bigger than it actually appears. |
FIGURE 4
|
STEP 5A: (FIGURE 6) Make cell F2 the active cell.
STEP 5B: (FIGURE 7) Move the mouse up to the Ribbon, Editing section. Locate the icon AutoSum. If you point at the icon with the mouse, it will state “Sum”. You will see a description of what AutoSum does. AutoSum is also found in Formulas toolbar, Function Library section.
|
FIGURE 6
FIGURE 7
|
STEP 6: (FIGURE 8) The AutoSum default is SUM. (More choices are available if you select the downward-pointing arrow to the right)
Notice that we can AutoSum numbers using other functions such as Average, Max, and Min. To view this drop-down menu, you must move the mouse up to the downward pointing arrowhead and click the mouse. |
FIGURE 8
|
STEP 9A: (FIGURE 11) Press the Enter key. The AutoSum will execute, summing the numbers and outputting the result in cell F2.
|
FIGURE 11
FIGURE 12
|
STEP 11: (FIGURE 14) Answer is 34. We will AutoFill the remaining cells. Make cell B6 the active cell.
Move mouse down to lower right corner of cell and get the small black cross. |
FIGURE 14
|
STEP 13: (FIGURE 16) Answer is 24. Make cell B7 the active cell. AutoFill the remaining cells. Move mouse down to lower right corner of cell and get the small black cross.
Hold down mouse button and drag across through cell E7 and release mouse button. Cells C7 through E7 populate with data. |
FIGURE 16
|
STEP 15: (FIGURE 18) Answer is 21. Make cell B8 the active cell. AutoFill the remaining cells. Move mouse down to lower right corner of cell and get the small black cross and drag across through cell E8. Cells C8 through E8 populate.
Hold down mouse button and drag across through cell E8 and release mouse button. Cells C8 through E8 populate with data. |
FIGURE 18
|
Section completed. Go to Module 4 Section 4.5 Practice Exercise 9; Use Absolute Addressing to Calculate