Lookup & Reference =FILTER(array,include,[if_empty])

Quiz =FILTER — 10 Questions

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

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

← FILTER ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =FILTER return a dynamic array?

Question 2 of 10 2/10

Which function is NOT related to =FILTER?

Question 3 of 10 3/10

Is argument “array” required in =FILTER?

Question 4 of 10 4/10

What is the type of argument “array” in =FILTER?

Question 5 of 10 5/10

What is the type of argument “include” in =FILTER?

Question 6 of 10 6/10

Is argument “if_empty]” required in =FILTER?

Question 7 of 10 7/10

Which function is related to =FILTER?

Question 8 of 10 8/10

Is =FILTER volatile?

Question 9 of 10 9/10

Which formula is a valid example of =FILTER?

Question 10 of 10 10/10

Which use case fits =FILTER?

Click a question to see the answer.

1. Does =FILTER return a dynamic array?

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

Explanation: FILTER spills as a dynamic array.

2. Which function is NOT related to =FILTER?

A. SUMXMY2 ✓
B. XLOOKUP
C. SORT
D. UNIQUE

Explanation: “SUMXMY2” is not related to FILTER.

3. Is argument “array” required in =FILTER?

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

Explanation: “array” is required.

4. What is the type of argument “array” in =FILTER?

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

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

5. What is the type of argument “include” in =FILTER?

A. Date
B. Range
C. Any type ✓
D. Array

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

6. Is argument “if_empty]” required in =FILTER?

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

Explanation: “if_empty]” is optional.

7. Which function is related to =FILTER?

A. SERIESSUM
B. RANK.EQ
C. SORT ✓
D. PERMUT

Explanation: “SORT” is related to FILTER.

8. Is =FILTER volatile?

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

Explanation: FILTER is not volatile.

9. Which formula is a valid example of =FILTER?

A. =SORT(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")
B. =FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"", 0)
C. =FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"") ✓
D. FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")

Explanation: Correct example: =FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")

10. Which use case fits =FILTER?

A. Daily Tasks ✓
B. Conditional Logic
C. Dynamic Ranges & Dashboards
D. Date & Time Calculations

Explanation: Use case “Daily Tasks” fits FILTER.