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

Quiz =SUBTOTAL — 10 Questions

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

Question 1 of 10 1/10

What is the output type of =SUBTOTAL?

Question 2 of 10 2/10

What usually causes #VALUE! in =SUBTOTAL?

Question 3 of 10 3/10

Which category does =SUBTOTAL belong to?

Question 4 of 10 4/10

Which use case fits =SUBTOTAL?

Question 5 of 10 5/10

Which function is related to =SUBTOTAL?

Question 6 of 10 6/10

In =SUBTOTAL, which is argument #2?

Question 7 of 10 7/10

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

Question 8 of 10 8/10

Which statement about =SUBTOTAL is correct?

Question 9 of 10 9/10

Which function is NOT related to =SUBTOTAL?

Question 10 of 10 10/10

In =SUBTOTAL, which is argument #3?

Click a question to see the answer.

1. What is the output type of =SUBTOTAL?

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

Explanation: Output is “Number”.

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

A. Text is always ignored
B. Output is always a dynamic array
C. Volatile and recalculates every time
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

3. Which category does =SUBTOTAL belong to?

A. Text
B. Logical
C. Math & Trig ✓
D. Cube

Explanation: Category is “Math & Trig”.

4. Which use case fits =SUBTOTAL?

A. Daily Tasks ✓
B. Loans & Installments
C. Numbering & Sample Data
D. Date & Time Calculations

Explanation: Use case “Daily Tasks” fits SUBTOTAL.

5. Which function is related to =SUBTOTAL?

A. IMSUB
B. FORECAST.ETS.SEASONALITY
C. BINOM.DIST
D. AGGREGATE ✓

Explanation: “AGGREGATE” is related to SUBTOTAL.

6. In =SUBTOTAL, which is argument #2?

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

Explanation: Argument #2 is “ref1”.

7. What is the type of argument “ref1” in =SUBTOTAL?

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

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

8. Which statement about =SUBTOTAL is correct?

A. Select entire column for best performance
B. Only works in old versions
C. The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use.
D. If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting. ✓

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

9. Which function is NOT related to =SUBTOTAL?

A. AGGREGATE
B. COUNTA
C. CHISQ.DIST.RT ✓
D. SUM

Explanation: “CHISQ.DIST.RT” is not related to SUBTOTAL.

10. In =SUBTOTAL, which is argument #3?

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

Explanation: Argument #3 is “ref2”.