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

Since which Excel version is =SUBTOTAL available?

Question 2 of 10 2/10

In =SUBTOTAL, which is argument #2?

Question 3 of 10 3/10

In =SUBTOTAL, which is argument #1?

Question 4 of 10 4/10

What is the output type of =SUBTOTAL?

Question 5 of 10 5/10

Which statement about =SUBTOTAL is correct?

Question 6 of 10 6/10

Which use case fits =SUBTOTAL?

Question 7 of 10 7/10

In =SUBTOTAL, which is argument #3?

Question 8 of 10 8/10

Is argument “ref2” required in =SUBTOTAL?

Question 9 of 10 9/10

Is argument “function_num” required in =SUBTOTAL?

Question 10 of 10 10/10

Is =SUBTOTAL volatile?

Click a question to see the answer.

1. Since which Excel version is =SUBTOTAL available?

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

Explanation: Version: “All versions”.

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

A. ref1 ✓
B. function_num
C. ref2
D. value

Explanation: Argument #2 is “ref1”.

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

A. range
B. ref2
C. function_num ✓
D. ref1

Explanation: Argument #1 is “function_num”.

4. What is the output type of =SUBTOTAL?

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

Explanation: Output is “Number”.

5. Which statement about =SUBTOTAL is correct?

A. The SUBTOTAL function ignores any rows that are not included in the result of a filter, no matter which function_num value you use.
B. 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.
C. If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting. ✓
D. Requires add-in

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

6. Which use case fits =SUBTOTAL?

A. Dynamic Ranges & Dashboards
B. Data Cleaning
C. Lookup & Retrieval
D. Daily Tasks ✓

Explanation: Use case “Daily Tasks” fits SUBTOTAL.

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

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

Explanation: Argument #3 is “ref2”.

8. Is argument “ref2” required in =SUBTOTAL?

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

Explanation: “ref2” is optional.

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

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

Explanation: “function_num” is required.

10. Is =SUBTOTAL volatile?

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

Explanation: SUBTOTAL is not volatile.