Filtering with filter views in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a filter view on the range A1:C10.

Google Sheets

Data > [1] > Create new filter view

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

AFilter views

BSort

CPivot table

DChart

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Sort' instead of 'Filter views' from the Data menu.

Trying to create a filter view from the Chart menu.

To create a filter view, you go to the Data menu and select Filter views.

2fill in blank

medium

Complete the code to apply a filter view that shows only rows where the value in column B is greater than 50.

Google Sheets

Click the filter icon in column B header > [1] > Greater than > Enter 50

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

ASort by color

BFilter by values

CFilter by condition

DSort A-Z

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Sort A-Z' which only sorts data, not filters it.

Using 'Filter by values' which filters by specific listed values, not conditions.

To filter rows by a condition like 'greater than 50', use 'Filter by condition'.

3fill in blank

hard

Fix the error in the filter view formula to show only rows where column C contains the word 'Complete'.

Google Sheets

Filter by condition > Text contains > [1]

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

Acomplete

BComplete

CCOMPLETE

Dcomplet

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase 'complete' which does not match the exact text.

Using partial words like 'complet' which do not match.

Use 'Complete' with a capital C to match exactly.

4fill in blank

hard

Fill both blanks to create a filter view that shows rows where column A is not empty and column B is less than 100.

Google Sheets

Filter by condition > [1] > Filter by condition > [2]

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

AIs not empty

BIs empty

CLess than

DGreater than

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Is empty' instead of 'Is not empty' for column A.

Using 'Greater than' instead of 'Less than' for column B.

Use 'Is not empty' to filter non-empty cells in column A, and 'Less than' to filter values less than 100 in column B.

5fill in blank

hard

Fill all three blanks to create a filter view that shows rows where column A starts with 'A', column B is greater than 20, and column C is not empty.

Google Sheets

Filter by condition > [1] > Filter by condition > [2] > Filter by condition > [3]

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

AText starts with

BGreater than

CIs not empty

DText ends with

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Text ends with' instead of 'Text starts with' for column A.

Using 'Less than' instead of 'Greater than' for column B.

Using 'Is empty' instead of 'Is not empty' for column C.

Use 'Text starts with' for column A, 'Greater than' for column B, and 'Is not empty' for column C to filter as required.