Which Excel function returns the smallest value from a set of numbers?

Which Excel function returns the smallest value from a set of numbers?

• A. MAX
• B. MEDIAN
• C. MIN
• D. AVERAGE

Answer: (D)

MIN is the function that returns the smallest value from a set of numbers. It scans the provided numbers (like a range such as A1:A10 or a list like 3, 7, 2, 9) and outputs the lowest one. For example, =MIN(3, 7, 2, 9) yields 2. MAX returns the largest value, MEDIAN returns the middle value (or the average of the two middle values when there are an even number of values), and AVERAGE calculates the arithmetic mean. So the smallest value is obtained with MIN.

MIN is the function that returns the smallest value from a set of numbers. It scans the provided numbers (like a range such as A1:A10 or a list like 3, 7, 2, 9) and outputs the lowest one. For example, =MIN(3, 7, 2, 9) yields 2. MAX returns the largest value, MEDIAN returns the middle value (or the average of the two middle values when there are an even number of values), and AVERAGE calculates the arithmetic mean. So the smallest value is obtained with MIN.