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

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)