Statistical =SMALL(array, k)

Quiz =SMALL — 15 Questions

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

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

← SMALL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is =SMALL volatile?

Question 2 of 15 2/15

Which use case fits =SMALL?

Question 3 of 15 3/15

How many required arguments does =SMALL have?

Question 4 of 15 4/15

Does =SMALL return a dynamic array?

Question 5 of 15 5/15

Which is the correct syntax of =SMALL?

Question 6 of 15 6/15

Which formula is a valid example of =SMALL?

Question 7 of 15 7/15

Is argument “array” required in =SMALL?

Question 8 of 15 8/15

In =SMALL, which is argument #1?

Question 9 of 15 9/15

Which function is related to =SMALL?

Question 10 of 15 10/15

How many arguments does =SMALL have in total?

Question 11 of 15 11/15

Which statement about =SMALL is correct?

Question 12 of 15 12/15

Since which Excel version is =SMALL available?

Question 13 of 15 13/15

What is the type of argument “array” in =SMALL?

Question 14 of 15 14/15

What usually causes #NUM! in =SMALL?

Question 15 of 15 15/15

Which category does =SMALL belong to?

Click a question to see the answer.

1. Is =SMALL volatile?

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

Explanation: SMALL is not volatile.

2. Which use case fits =SMALL?

A. Workdays & Due Dates
B. Numbering & Sample Data
C. Ranking & Top N ✓
D. Data Cleaning

Explanation: Use case “Ranking & Top N” fits SMALL.

3. How many required arguments does =SMALL have?

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

Explanation: =SMALL has 2 required, 0 optional (2 total).

4. Does =SMALL return a dynamic array?

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

Explanation: SMALL does not spill.

5. Which is the correct syntax of =SMALL?

A. =SMALL(array, k) ✓
B. SMALL(array, k)
C. =LARGE(array, k)
D. =SMALL(array, k, 0)

Explanation: Correct syntax: =SMALL(array, k)

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

A. =LARGE(A2:A10,4)
B. =SMALL(A2:A10,4, 0)
C. =SMALL(A2:A10,4) ✓
D. SMALL(A2:A10,4)

Explanation: Correct example: =SMALL(A2:A10,4)

7. Is argument “array” required in =SMALL?

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

Explanation: “array” is required.

8. In =SMALL, which is argument #1?

A. k
B. array ✓
C. criteria
D. lookup_value

Explanation: Argument #1 is “array”.

9. Which function is related to =SMALL?

A. BINOMDIST
B. LARGE ✓
C. ISBLANK
D. TEXTAFTER

Explanation: “LARGE” is related to SMALL.

10. How many arguments does =SMALL have in total?

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

Explanation: =SMALL has 2 required, 0 optional (2 total).

11. Which statement about =SMALL is correct?

A. Select entire column for best performance
B. Only works in old versions
C. If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value. ✓
D. Volatile and recalculates every time

Explanation: Correct: If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value.

12. Since which Excel version is =SMALL available?

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

Explanation: Version: “All versions”.

13. What is the type of argument “array” in =SMALL?

A. Reference
B. Mixed
C. Array ✓
D. Date

Explanation: Type of “array” is “Array”.

14. What usually causes #NUM! in =SMALL?

A. Output is always a dynamic array
B. If array is empty, SMALL returns the #NUM! error value. If k ≤ 0 or if k exceeds the number of data points, SMALL returns the #NUM! error value. ✓
C. Requires add-in
D. Only works in old versions

Explanation: If array is empty, SMALL returns the #NUM! error value. If k ≤ 0 or if k exceeds the number of data points, SMALL returns the #NUM! error value. — Fix: Check the second argument

15. Which category does =SMALL belong to?

A. Logical
B. Web
C. Statistical ✓
D. Lookup & Reference

Explanation: Category is “Statistical”.