functions. These functions identify the highest and lowest values in a range of cells. The following steps
explain how to add these functions to the Budget Detail worksheet:
1. Click cell D15 in the Budget Detail worksheet.
2. Type an equal sign (=).
3. Type the word MIN.
4. Type an open parenthesis (().
6. Type a closing parenthesis ()).
7. Press the ENTER key. The MIN function produces an output of $1,200, which is the lowest value
in the Annual Spend column (see Figure 2.24 "MIN Function Added to the Budget Detail
Worksheet").
8. Click cell D16.
9. Type an equal sign (=).
10. Type the word MAX.
11. Type an open parenthesis (().
12. Highlight the range D3:D11.
13. Type a closing parenthesis ()).
14. Press the ENTER key. The MAX function produces an output of $3,500. This is the highest value
in the Annual Spend column (see Figure 2.25 "MAX Function Added to the Budget Detail
Worksheet").
Skill Refresher: Statistical Functions
1. Type an equal sign (=).
2. Type the function name followed by an open parenthesis (() or double click the function name
from the function list.
3. Highlight a range on a worksheet or click individual cell locations followed by commas.
4. Type a closing parenthesis ()).
5. Press the ENTER key.
0 comments:
Post a Comment