Filter views vs filters in Google Sheets - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a filter that shows only rows where the value in column A is greater than 10.

Google Sheets

FILTER(A2:H100, A2:A100 [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 the wrong rows.

Using = will only show rows equal to 10, not greater.

The filter condition should check if values in column A are greater than 10, so the correct operator is >.

2fill in blank

medium

Complete the code to apply a filter that shows only rows where scores in column B are at least 80.

Google Sheets

FILTER(A2:H100, B2:B100 [1] 80)

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

A>=

B<

C<=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using > will exclude scores exactly equal to 80.

Using < or <= will filter out high scores.

To include scores 80 and above, use the >= operator which means 'greater than or equal to'.

3fill in blank

hard

Fix the error in the filter formula to correctly show rows where column C equals 'Complete'.

Google Sheets

FILTER(A2:H100, C2:C100 [1] "Complete")

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

A==

B=

C===

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using == or === causes a formula error.

Using != filters out rows equal to 'Complete'.

In Google Sheets formulas, the single equals sign = is used for comparison, not == or ===.

4fill in blank

hard

Fill both blanks to create a filter that shows rows where column D is not empty and column E is less than 50.

Google Sheets

FILTER(A2:H100, D2:D100 [1] "", E2:E100 [2] 50)

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

A<>

B=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using = "" filters only empty cells.

Using > 50 filters numbers greater than 50.

To check if a cell is not empty, use <> "". To filter values less than 50, use < 50.

5fill in blank

hard

Fill all three blanks to create a filter that shows rows where column F is 'Yes', column G is greater than 100, and column H is not empty.

Google Sheets

FILTER(A2:H100, F2:F100 [1] "Yes", G2:G100 [2] 100, H2:H100 [3] "")

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

A=

B>

C<>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using < 100 filters numbers less than 100.

Using = "" filters empty cells.

Use = "Yes" to match exact text, > 100 for numbers greater than 100, and <> "" to check cells are not empty.