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 “filter_array” in =PIVOTBY?

Question 2 of 15 2/15

Is argument “filter_array” required in =PIVOTBY?

Question 3 of 15 3/15

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

Question 4 of 15 4/15

Is =PIVOTBY volatile?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

In =PIVOTBY, which is argument #2?

Question 7 of 15 7/15

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

Question 8 of 15 8/15

Which function is related to =PIVOTBY?

Question 9 of 15 9/15

Is argument “row_fields” required in =PIVOTBY?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which use case fits =PIVOTBY?

Question 12 of 15 12/15

Is argument “function” required in =PIVOTBY?

Question 13 of 15 13/15

Is argument “field_headers” required in =PIVOTBY?

Question 14 of 15 14/15

Is argument “row_total_depth” required in =PIVOTBY?

Question 15 of 15 15/15

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

Click a question to see the answer.

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

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

Explanation: Type of “filter_array” is “Logical”.

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

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

Explanation: “filter_array” is required.

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

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

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

4. Is =PIVOTBY volatile?

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

Explanation: PIVOTBY is not volatile.

5. What is the type of argument “row_fields” in =PIVOTBY?

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

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

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

A. col_fields ✓
B. lookup_value
C. relative_to
D. filter_array

Explanation: Argument #2 is “col_fields”.

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

A. Number ✓
B. Any type
C. Value
D. Text

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

8. Which function is related to =PIVOTBY?

A. FORECAST.LINEAR
B. SIGN
C. COLUMN
D. PERCENTOF ✓

Explanation: “PERCENTOF” is related to PIVOTBY.

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

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

Explanation: “row_fields” is required.

10. What is the type of argument “row_sort_order” in =PIVOTBY?

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

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

11. Which use case fits =PIVOTBY?

A. Date & Time Calculations
B. Reporting ✓
C. Loans & Installments
D. Data Cleaning

Explanation: Use case “Reporting” fits PIVOTBY.

12. Is argument “function” required in =PIVOTBY?

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

Explanation: “function” is required.

13. Is argument “field_headers” required in =PIVOTBY?

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

Explanation: “field_headers” is required.

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

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

Explanation: “row_total_depth” is required.

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

A. Reference
B. Mixed
C. Array
D. Range ✓

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