graphic2

 

Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions: Demonstrate How To Apply the MAX Function

graphhic1
Formulas->Function Library->AutoSum ->Max

 

The MAX Function

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)