|
Excel: A Question of Balance
The MAX
Function finds the greatest value in a range. In this example, the MAX
will display the highest salary. Try It: Use
the MAX Function Select Cell
D9. Go to
Formulas -> AutoSum Click on
MAX.
Excel wrote the following equation:
=MAX(D2:D8)
This is the
wrong range. Use your
cursor to highlight (select) Cells D2:D4.
What Do You
See Now?
The correct
equation is:
=MAX(D2:D4)
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.2. Summarize data using a formula 3.2.1. Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX