Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE,
MIN, and MAX: MAX The MAX
Function finds the greatest value in a range. In this example, the MAX
will display the highest salary. 1. Try It: Use
the MAX Function Select Cell
D8. Go to
Formulas ->Function Library Go to AutoSum. Click on
MAX.
Excel wrote the following equation:
=MAX(D2:D7)
This is the
wrong range. Use your
cursor to highlight (select) Cells D2:D4.
2. What Do You
See Now?
The correct
equation is:
=MAX(D2:D4)
|
|
| |
