Statistical =MIN(number1, [number2], ...)

Quiz =MIN — 15 Questions

15 quiz questions about =MIN — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← MIN ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

How many arguments does =MIN have in total?

Question 2 of 15 2/15

Which use case fits =MIN?

Question 3 of 15 3/15

Is argument “number1” required in =MIN?

Question 4 of 15 4/15

Which statement about =MIN is correct?

Question 5 of 15 5/15

Which function is NOT related to =MIN?

Question 6 of 15 6/15

Which formula is a valid example of =MIN?

Question 7 of 15 7/15

Does =MIN return a dynamic array?

Question 8 of 15 8/15

Which is the correct syntax of =MIN?

Question 9 of 15 9/15

In =MIN, which is argument #1?

Question 10 of 15 10/15

Is =MIN volatile?

Question 11 of 15 11/15

Since which Excel version is =MIN available?

Question 12 of 15 12/15

What is the type of argument “number1” in =MIN?

Question 13 of 15 13/15

Which function is related to =MIN?

Question 14 of 15 14/15

How many optional arguments does =MIN have?

Question 15 of 15 15/15

What is the output type of =MIN?

Click a question to see the answer.

1. How many arguments does =MIN have in total?

A. 1 ✓
B. 0
C. 3
D. 2

Explanation: =MIN has 0 required, 1 optional (1 total).

2. Which use case fits =MIN?

A. Investment Appraisal
B. Daily Tasks ✓
C. Sort, Filter & Dedupe
D. Reshape Tables

Explanation: Use case “Daily Tasks” fits MIN.

3. Is argument “number1” required in =MIN?

A. —
B. Yes
C. No ✓
D. No

Explanation: “number1” is optional.

4. Which statement about =MIN is correct?

A. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓
B. Volatile and recalculates every time
C. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
D. Requires add-in

Explanation: Correct: Arguments can either be numbers or names, arrays, or references that contain numbers.

5. Which function is NOT related to =MIN?

A. AVERAGE ✓
B. MINA
C. MAX
D. MINIFS

Explanation: “AVERAGE” is not related to MIN.

6. Which formula is a valid example of =MIN?

A. =MIN(A2:A6, 0)
B. =MIN(A2:A6) ✓
C. =MAX(A2:A6)
D. MIN(A2:A6)

Explanation: Correct example: =MIN(A2:A6)

7. Does =MIN return a dynamic array?

A. Yes
B. No
C. —
D. No ✓

Explanation: MIN does not spill.

8. Which is the correct syntax of =MIN?

A. =MIN(number1, [number2], ..., 0)
B. =MAX(number1, [number2], ...)
C. =MIN(number1, [number2], ...) ✓
D. MIN(number1, [number2], ...)

Explanation: Correct syntax: =MIN(number1, [number2], ...)

9. In =MIN, which is argument #1?

A. criteria
B. number1 ✓
C. value
D. range

Explanation: Argument #1 is “number1”.

10. Is =MIN volatile?

A. —
B. Yes
C. No
D. No ✓

Explanation: MIN is not volatile.

11. Since which Excel version is =MIN available?

A. Excel 2019
B. All versions ✓
C. Excel 365
D. Excel 2007 (Compatibility)

Explanation: Version: “All versions”.

12. What is the type of argument “number1” in =MIN?

A. Date
B. Number ✓
C. Array
D. Logical

Explanation: Type of “number1” is “Number”.

13. Which function is related to =MIN?

A. ASIN
B. MAX ✓
C. XOR
D. LOGINV

Explanation: “MAX” is related to MIN.

14. How many optional arguments does =MIN have?

A. 1 ✓
B. 2
C. 0
D. 3

Explanation: =MIN has 0 required, 1 optional (1 total).

15. What is the output type of =MIN?

A. Reference
B. Mixed
C. Text
D. Number ✓

Explanation: Output is “Number”.