Math & Trig =SUBTOTAL(function_num,ref1,[ref2],...)

Quiz =SUBTOTAL — 15 Questions

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

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

← SUBTOTAL ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

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

Question 2 of 15 2/15

Which is the correct syntax of =SUBTOTAL?

Question 3 of 15 3/15

Which function is related to =SUBTOTAL?

Question 4 of 15 4/15

Which formula is a valid example of =SUBTOTAL?

Question 5 of 15 5/15

How many required arguments does =SUBTOTAL have?

Question 6 of 15 6/15

Is =SUBTOTAL volatile?

Question 7 of 15 7/15

Which statement about =SUBTOTAL is correct?

Question 8 of 15 8/15

In =SUBTOTAL, which is argument #1?

Question 9 of 15 9/15

Is argument “ref1” required in =SUBTOTAL?

Question 10 of 15 10/15

What is the type of argument “ref2” in =SUBTOTAL?

Question 11 of 15 11/15

What is the type of argument “function_num” in =SUBTOTAL?

Question 12 of 15 12/15

How many optional arguments does =SUBTOTAL have?

Question 13 of 15 13/15

What usually causes #VALUE! in =SUBTOTAL?

Question 14 of 15 14/15

Which function is NOT related to =SUBTOTAL?

Question 15 of 15 15/15

What is the output type of =SUBTOTAL?

Click a question to see the answer.

1. What is the fix for #VALUE! in =SUBTOTAL?

A. Volatile and recalculates every time
B. Only works in old versions
C. Requires add-in
D. Check the first argument ✓

Explanation: If any of the references are 3-D references, SUBTOTAL returns the #VALUE! error value. — Fix: Check the first argument

2. Which is the correct syntax of =SUBTOTAL?

A. =SUBTOTAL(function_num,ref1,[ref2],..., 0)
B. SUBTOTAL(function_num,ref1,[ref2],...)
C. =SUBTOTAL(function_num,ref1,[ref2],...) ✓
D. =AGGREGATE(function_num,ref1,[ref2],...)

Explanation: Correct syntax: =SUBTOTAL(function_num,ref1,[ref2],...)

3. Which function is related to =SUBTOTAL?

A. AGGREGATE ✓
B. PERMUTATIONA
C. FIXED
D. PV

Explanation: “AGGREGATE” is related to SUBTOTAL.

4. Which formula is a valid example of =SUBTOTAL?

A. =SUBTOTAL(9,A2:A5) ✓
B. =AGGREGATE(9,A2:A5)
C. =SUBTOTAL(9,A2:A5, 0)
D. SUBTOTAL(9,A2:A5)

Explanation: Correct example: =SUBTOTAL(9,A2:A5)

5. How many required arguments does =SUBTOTAL have?

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

Explanation: =SUBTOTAL has 2 required, 1 optional (3 total).

6. Is =SUBTOTAL volatile?

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

Explanation: SUBTOTAL is not volatile.

7. Which statement about =SUBTOTAL is correct?

A. Volatile and recalculates every time
B. If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting. ✓
C. Only works in old versions
D. For the function_num constants from 1 to 11, the SUBTOTAL function includes the values of rows hidden by the Hide Rows command under the Hide & Unhide submenu of the Format command in the Cells group on the Home tab in the Excel desktop application. Use these constants when you want to subtotal hidden and nonhidden numbers in a list. For the function_Num constants from 101 to 111, the SUBTOTAL function ignores values of rows hidden by the Hide Rows command. Use these constants when you want to subtotal only nonhidden numbers in a list.

Explanation: Correct: If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting.

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

A. lookup_value
B. criteria
C. function_num ✓
D. ref2

Explanation: Argument #1 is “function_num”.

9. Is argument “ref1” required in =SUBTOTAL?

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

Explanation: “ref1” is required.

10. What is the type of argument “ref2” in =SUBTOTAL?

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

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

11. What is the type of argument “function_num” in =SUBTOTAL?

A. Reference
B. Array
C. Any type ✓
D. Logical

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

12. How many optional arguments does =SUBTOTAL have?

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

Explanation: =SUBTOTAL has 2 required, 1 optional (3 total).

13. What usually causes #VALUE! in =SUBTOTAL?

A. Only works in old versions
B. Volatile and recalculates every time
C. Requires add-in
D. If any of the references are 3-D references, SUBTOTAL returns the #VALUE! error value. ✓

Explanation: If any of the references are 3-D references, SUBTOTAL returns the #VALUE! error value. — Fix: Check the first argument

14. Which function is NOT related to =SUBTOTAL?

A. SUM
B. AGGREGATE
C. GAMMA.INV ✓
D. COUNTA

Explanation: “GAMMA.INV” is not related to SUBTOTAL.

15. What is the output type of =SUBTOTAL?

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

Explanation: Output is “Number”.