Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions: Demonstrate How To Apply the MIN Function
graphic1
Formulas->Function Library->AutoSum ->MIN
graphic2

 

The MIN Function

The MIN Function finds the least value in a range. In this example, the Min will determine the smallest salary.

 

1. Try It: Use the MIN Function

Select Cell D9.

Go to Formulas ->Function Library.

Go to AutoSum.

Click on Min.

 

Excel wrote the following equation:

=MIN(D2:D8)

This is the wrong range.

 

Use your cursor to highlight (select) Cells D2:D4.

 

2. What Do You See Now?

The correct equation is:

=MIN(D2:D4)