Microsoft Office Tutorials and References
In Depth Information
FIGURE 3.9 AutoSum Result
FIGURE 3.10 Excel Function Menus
To use all other functions in Excel, you can insert the function by using the
next to the formula bar or by using the shortcut Shift
insert the Average function in cell D12, click the Function icon or use Shift
Function menu will appear on the screen. Click on the drop-down menu and choose
Statistical. See Figure 3.10.
On the menu, select Average and click OK. In the first cell of the Average menu
cell, select D3:D10 and click OK. It will result in the average. See Figure 3.11.
Once you have the two functions as shown in Figure 3.11, you can select the two
results in D11:D12 and place your mouse pointer at the drag handle as shown in
Now drag it to the right through column F, taking advantage of the relative
addressing in the sum and average of all three columns. The results and formulas are
shown in Figure 3.13.
This chapter introduced formulas, functions, and the addressing issues in Excel.
We showed how to use these formulas in a simple way. We also demonstrated how to
take advantage of the shortcuts and the dragging to duplicate the results for entire
columns and rows. The focus is on speed, accuracy, efficiency, and the ability to
duplicate the functions and formulas. We will use these techniques again throughout
the rest of the topic.