Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
To Determine the Total Tax Percentage
With the totals in row 13 determined, the next step is to copy the tax percentage
formula in cell H12 to cell H13. The following step copies the tax percentage formula.
Select the cell to be copied, H12 in this case, and then drag the fill handle down
through cell H13 to copy the formula (Figure 2 – 14).
Why was the SUM function not used for tax percentage in H13?
The tax percentage is based off of the totals, not the sum, of the tax percentage column;
therefore, there was no need to use the SUM function.
formula copied
from H12 to H13
Figure 2 – 14
Using the AVERAGE, MAX, and MIN Functions
The next step in creating the HyperMass Online Storage Salary Report worksheet
is to compute the highest value, lowest value, and average value for the number of
dependents listed in the range B4:B12 using the MAX, MIN, and AVERAGE functions
in the range B14:B16. Once the values are determined for column B, the entries can be
copied across to the other columns.
With Excel, you can enter functions using one of ve methods: (1) keyboard,
touch gesture, or pointer; (2) the Insert Function box in the formula bar; (3) the Sum
menu; (4) the Sum button (FORMULAS tab | Function Library group); and (5) the
Name box area in the formula bar. The method you choose will depend on your typing
skills and whether you can recall the function name and required arguments.
In the following sections, three of these methods will be used. The Insert
Function box in the formula bar method will be used to determine the highest number
of dependents (cell B14). The Sum menu will be used to determine the lowest number
of dependents (cell B15). The keyboard and pointer will be used to determine the
average number of dependents (cell B16).
Search JabSto ::

Custom Search