Lookup & Reference =PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to])

Quiz =PIVOTBY — 15 Questions

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

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

← PIVOTBY ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Is argument “row_total_depth” required in =PIVOTBY?

Question 2 of 15 2/15

Which category does =PIVOTBY belong to?

Question 3 of 15 3/15

What is the type of argument “col_fields” in =PIVOTBY?

Question 4 of 15 4/15

Which formula is a valid example of =PIVOTBY?

Question 5 of 15 5/15

In =PIVOTBY, which is argument #3?

Question 6 of 15 6/15

Since which Excel version is =PIVOTBY available?

Question 7 of 15 7/15

What is the type of argument “row_total_depth” in =PIVOTBY?

Question 8 of 15 8/15

What is the type of argument “col_total_depth” in =PIVOTBY?

Question 9 of 15 9/15

Is argument “col_total_depth” required in =PIVOTBY?

Question 10 of 15 10/15

In =PIVOTBY, which is argument #1?

Question 11 of 15 11/15

What is the type of argument “function” in =PIVOTBY?

Question 12 of 15 12/15

Which function is NOT related to =PIVOTBY?

Question 13 of 15 13/15

In =PIVOTBY, which is argument #2?

Question 14 of 15 14/15

Which is the correct syntax of =PIVOTBY?

Question 15 of 15 15/15

Is argument “row_fields” required in =PIVOTBY?

Click a question to see the answer.

1. Is argument “row_total_depth” required in =PIVOTBY?

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

Explanation: “row_total_depth” is required.

2. Which category does =PIVOTBY belong to?

A. Math & Trig
B. Database
C. Lookup & Reference ✓
D. Cube

Explanation: Category is “Lookup & Reference”.

3. What is the type of argument “col_fields” in =PIVOTBY?

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

Explanation: Type of “col_fields” is “Range”.

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

A. =PIVOTBY(B2:B100, A2:A100, D2:D100, SUM, 0)
B. =PIVOTBY(B2:B100, A2:A100, D2:D100, SUM) ✓
C. PIVOTBY(B2:B100, A2:A100, D2:D100, SUM)
D. =PERCENTOF(B2:B100, A2:A100, D2:D100, SUM)

Explanation: Correct example: =PIVOTBY(B2:B100, A2:A100, D2:D100, SUM)

5. In =PIVOTBY, which is argument #3?

A. relative_to
B. values ✓
C. col_fields
D. field_headers

Explanation: Argument #3 is “values”.

6. Since which Excel version is =PIVOTBY available?

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

Explanation: Version: “Excel 365”.

7. What is the type of argument “row_total_depth” in =PIVOTBY?

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

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

8. What is the type of argument “col_total_depth” in =PIVOTBY?

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

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

9. Is argument “col_total_depth” required in =PIVOTBY?

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

Explanation: “col_total_depth” is required.

10. In =PIVOTBY, which is argument #1?

A. col_fields
B. range
C. row_total_depth
D. row_fields ✓

Explanation: Argument #1 is “row_fields”.

11. What is the type of argument “function” in =PIVOTBY?

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

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

12. Which function is NOT related to =PIVOTBY?

A. GROUPBY
B. RANK.AVG ✓
C. PERCENTOF
D. COUNTIFS

Explanation: “RANK.AVG” is not related to PIVOTBY.

13. In =PIVOTBY, which is argument #2?

A. relative_to
B. row_fields
C. field_headers
D. col_fields ✓

Explanation: Argument #2 is “col_fields”.

14. Which is the correct syntax of =PIVOTBY?

A. =PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to], 0)
B. =PERCENTOF(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to])
C. PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to])
D. =PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to]) ✓

Explanation: Correct syntax: =PIVOTBY(row_fields,col_fields,values,function,[field_headers],[row_total_depth],[row_sort_order],[col_total_depth],[col_sort_order],[filter_array],[relative_to])

15. Is argument “row_fields” required in =PIVOTBY?

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

Explanation: “row_fields” is required.