Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE,
MIN, and MAX: MIN 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)
|
|
| |
