Statistical =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Quiz =MINIFS — 10 Questions

10 quiz questions about =MINIFS — test syntax, arguments, examples & errors!

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

← MINIFS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which use case fits =MINIFS?

Question 2 of 10 2/10

How many required arguments does =MINIFS have?

Question 3 of 10 3/10

In =MINIFS, which is argument #1?

Question 4 of 10 4/10

What is the type of argument “criteria_range2, criteria2” in =MINIFS?

Question 5 of 10 5/10

Which is the correct syntax of =MINIFS?

Question 6 of 10 6/10

Does =MINIFS return a dynamic array?

Question 7 of 10 7/10

What is the fix for #VALUE! in =MINIFS?

Question 8 of 10 8/10

What is the type of argument “criteria1” in =MINIFS?

Question 9 of 10 9/10

How many optional arguments does =MINIFS have?

Question 10 of 10 10/10

Is =MINIFS volatile?

Click a question to see the answer.

1. Which use case fits =MINIFS?

A. External Data, Web & Cube
B. Conditional Aggregation ✓
C. Securities & Bonds
D. Conditional Logic

Explanation: Use case “Conditional Aggregation” fits MINIFS.

2. How many required arguments does =MINIFS have?

A. 5
B. 2
C. 3 ✓
D. 4

Explanation: =MINIFS has 3 required, 1 optional (4 total).

3. In =MINIFS, which is argument #1?

A. criteria
B. min_range ✓
C. criteria1
D. criteria_range1

Explanation: Argument #1 is “min_range”.

4. What is the type of argument “criteria_range2, criteria2” in =MINIFS?

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

Explanation: Type of “criteria_range2, criteria2” is “Number”.

5. Which is the correct syntax of =MINIFS?

A. MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
B. =MAXIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
C. =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ..., 0)
D. =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) ✓

Explanation: Correct syntax: =MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

6. Does =MINIFS return a dynamic array?

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

Explanation: MINIFS does not spill.

7. What is the fix for #VALUE! in =MINIFS?

A. Output is always a dynamic array
B. Requires add-in
C. Select entire column for best performance
D. Make the value range and the criteria ranges the same size ✓

Explanation: The size and shape of the min_range and all criteria_range arguments must be the same, otherwise these functions return the #VALUE! error. — Fix: Make the value range and the criteria ranges the same size

8. What is the type of argument “criteria1” in =MINIFS?

A. Any type ✓
B. Date
C. Reference
D. Mixed

Explanation: Type of “criteria1” is “Any type”.

9. How many optional arguments does =MINIFS have?

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

Explanation: =MINIFS has 3 required, 1 optional (4 total).

10. Is =MINIFS volatile?

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

Explanation: MINIFS is not volatile.