Lookup & Reference =GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])

Quiz =GROUPBY — 10 Questions

10 quiz questions about =GROUPBY — test syntax, arguments, examples & errors!

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

← GROUPBY ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =GROUPBY return a dynamic array?

Question 2 of 10 2/10

Which use case fits =GROUPBY?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Since which Excel version is =GROUPBY available?

Question 5 of 10 5/10

Which is the correct syntax of =GROUPBY?

Question 6 of 10 6/10

Which function is NOT related to =GROUPBY?

Question 7 of 10 7/10

Which category does =GROUPBY belong to?

Question 8 of 10 8/10

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

Question 9 of 10 9/10

Is argument “sort_order” required in =GROUPBY?

Question 10 of 10 10/10

Is =GROUPBY volatile?

Click a question to see the answer.

1. Does =GROUPBY return a dynamic array?

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

Explanation: GROUPBY spills as a dynamic array.

2. Which use case fits =GROUPBY?

A. Reporting ✓
B. Conditional Logic
C. Rounding & Numeric
D. Workdays & Due Dates

Explanation: Use case “Reporting” fits GROUPBY.

3. What is the type of argument “field_headers” in =GROUPBY?

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

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

4. Since which Excel version is =GROUPBY available?

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

Explanation: Version: “Excel 365”.

5. Which is the correct syntax of =GROUPBY?

A. =GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship]) ✓
B. =PERCENTOF(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])
C. GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])
D. =GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship], 0)

Explanation: Correct syntax: =GROUPBY(row_fields,values,function,[field_headers],[total_depth],[sort_order],[filter_array],[field_relationship])

6. Which function is NOT related to =GROUPBY?

A. PIVOTBY
B. ISNUMBER ✓
C. SUMIFS
D. PERCENTOF

Explanation: “ISNUMBER” is not related to GROUPBY.

7. Which category does =GROUPBY belong to?

A. Lookup & Reference ✓
B. Statistical
C. Web
D. Compatibility

Explanation: Category is “Lookup & Reference”.

8. What is the type of argument “row_fields” in =GROUPBY?

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

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

9. Is argument “sort_order” required in =GROUPBY?

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

Explanation: “sort_order” is required.

10. Is =GROUPBY volatile?

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

Explanation: GROUPBY is not volatile.