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

Quiz =MIN — 10 Questions

10 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 — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =MIN is correct?

Question 2 of 10 2/10

Which category does =MIN belong to?

Question 3 of 10 3/10

Which formula is a valid example of =MIN?

Question 4 of 10 4/10

How many required arguments does =MIN have?

Question 5 of 10 5/10

How many arguments does =MIN have in total?

Question 6 of 10 6/10

How many optional arguments does =MIN have?

Question 7 of 10 7/10

Does =MIN return a dynamic array?

Question 8 of 10 8/10

Which is the correct syntax of =MIN?

Question 9 of 10 9/10

Which use case fits =MIN?

Question 10 of 10 10/10

Is =MIN volatile?

Click a question to see the answer.

1. Which statement about =MIN is correct?

A. If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
B. Select entire column for best performance
C. Logical values and text representations of numbers that you type directly into the list of arguments are counted.
D. Arguments can either be numbers or names, arrays, or references that contain numbers. ✓

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

2. Which category does =MIN belong to?

A. Cube
B. Web
C. Engineering
D. Statistical ✓

Explanation: Category is “Statistical”.

3. 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)

4. How many required arguments does =MIN have?

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

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

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

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

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

6. How many optional arguments does =MIN have?

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

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

7. Does =MIN return a dynamic array?

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

Explanation: MIN does not spill.

8. Which is the correct syntax of =MIN?

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

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

9. Which use case fits =MIN?

A. Error Handling
B. Advanced Formulas
C. Daily Tasks ✓
D. Probability & Hypothesis Testing

Explanation: Use case “Daily Tasks” fits MIN.

10. Is =MIN volatile?

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

Explanation: MIN is not volatile.