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.

1

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).