FILTER function in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to filter values in column A that are greater than 10.

Google Sheets

=FILTER(A2:A10, A2:A10 [1] 10)

Drag options to blanks, or click blank then click option'

A>

B<=

C<

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will filter values less than 10.

Using '=' will only filter values exactly equal to 10.

The FILTER function returns values from A2:A10 where the condition is true. Here, we want values greater than 10, so we use >.

2fill in blank

medium

Complete the formula to filter values in column B that are not empty.

Google Sheets

=FILTER(B2:B20, B2:B20 [1] "")

Drag options to blanks, or click blank then click option'

A<>

B=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' will filter only empty cells.

Using '>' or '<' does not correctly check for non-empty text.

The operator <> means 'not equal to'. This filters cells in B2:B20 that are not empty strings.

3fill in blank

hard

Fix the error in the formula to filter values in column C that are less than or equal to 50.

Google Sheets

=FILTER(C2:C15, C2:C15 [1] 50)

Drag options to blanks, or click blank then click option'

A=>

B<=

C<

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=>' which is not valid in Google Sheets formulas.

Using '==' which is not a valid comparison operator here.

The correct operator for 'less than or equal to' is <=. The option '=>' is invalid syntax.

4fill in blank

hard

Fill both blanks to filter values in column D that are between 20 and 40 inclusive.

Google Sheets

=FILTER(D2:D30, D2:D30 [1] 20, D2:D30 [2] 40)

Drag options to blanks, or click blank then click option'

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '<=' excludes 40 from results.

Using '>' instead of '>=' excludes 20 from results.

The formula filters values greater than or equal to 20 and less than or equal to 40. So use >= for the lower bound and <= for the upper bound.

5fill in blank

hard

Fill all three blanks to filter values in column E where values are greater than 5 and less than 15, and the corresponding value in column F is 'Yes'.

Google Sheets

=FILTER(E2:E25, E2:E25 [1] 5, E2:E25 [2] 15, F2:F25 [3] "Yes")

Drag options to blanks, or click blank then click option'

A>

B<

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using >= or <= instead of > or < changes the range.

Using <> instead of = for matching 'Yes' will filter out those rows.

The formula filters values in E2:E25 greater than 5 and less than 15, and only rows where F2:F25 equals 'Yes'. So use > for greater than, < for less than, and = for equality.