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

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

Question 2 of 15 2/15

Is argument “row_sort_order” required in =PIVOTBY?

Question 3 of 15 3/15

How many optional arguments does =PIVOTBY have?

Question 4 of 15 4/15

Is argument “relative_to” required in =PIVOTBY?

Question 5 of 15 5/15

Which formula is a valid example of =PIVOTBY?

Question 6 of 15 6/15

Which category does =PIVOTBY belong to?

Question 7 of 15 7/15

Is argument “filter_array” required in =PIVOTBY?

Question 8 of 15 8/15

Is argument “row_fields” required in =PIVOTBY?

Question 9 of 15 9/15

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

Question 10 of 15 10/15

In =PIVOTBY, which is argument #1?

Question 11 of 15 11/15

Since which Excel version is =PIVOTBY available?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

In =PIVOTBY, which is argument #3?

Question 14 of 15 14/15

Is argument “col_sort_order” required in =PIVOTBY?

Question 15 of 15 15/15

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

Click a question to see the answer.

1. What is the type of argument “field_headers” in =PIVOTBY?

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

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

2. Is argument “row_sort_order” required in =PIVOTBY?

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

Explanation: “row_sort_order” is required.

3. How many optional arguments does =PIVOTBY have?

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

Explanation: =PIVOTBY has 11 required, 0 optional (11 total).

4. Is argument “relative_to” required in =PIVOTBY?

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

Explanation: “relative_to” is required.

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

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

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

6. Which category does =PIVOTBY belong to?

A. Engineering
B. Web
C. Cube
D. Lookup & Reference ✓

Explanation: Category is “Lookup & Reference”.

7. Is argument “filter_array” required in =PIVOTBY?

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

Explanation: “filter_array” is required.

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

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

Explanation: “row_fields” is required.

9. What is the type of argument “values” in =PIVOTBY?

A. Mixed
B. Value
C. Range ✓
D. Date

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

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

A. row_sort_order
B. filter_array
C. row_fields ✓
D. value

Explanation: Argument #1 is “row_fields”.

11. Since which Excel version is =PIVOTBY available?

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

Explanation: Version: “Excel 365”.

12. What is the type of argument “col_sort_order” in =PIVOTBY?

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

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

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

A. col_total_depth
B. values ✓
C. criteria
D. lookup_value

Explanation: Argument #3 is “values”.

14. Is argument “col_sort_order” required in =PIVOTBY?

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

Explanation: “col_sort_order” is required.

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

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

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