Filtering PivotTable data in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to filter the pivot table data by the region "East".

Google Sheets

=FILTER(A2:D100, B2:B100 [1] "East")

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

A!=

B=

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using > or < instead of = causes wrong filtering.

Using != will exclude the "East" region instead of including it.

Use the equals sign = to filter rows where the region is exactly "East".

2fill in blank

medium

Complete the formula to filter pivot table data for sales greater than 500.

Google Sheets

=FILTER(A2:D100, D2:D100 [1] 500)

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

A=

B<=

C<

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using < or <= will filter the wrong rows.

Using = will only show rows with exactly 500 sales.

The greater than sign > filters rows where sales are more than 500.

3fill in blank

hard

Fix the error in the formula to filter data where the product is "Widget".

Google Sheets

=FILTER(A2:D100, C2:C100 [1] "Widget")

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

A=

B==

C!=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using == causes a formula error.

Using <> is for 'not equal' and will filter wrong data.

In Google Sheets, use a single equals sign = for comparison, not double equals.

4fill in blank

hard

Fill both blanks to filter data where the region is "West" and sales are less than 300.

Google Sheets

=FILTER(A2:D100, B2:B100 [1] "West", D2:D100 [2] 300)

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

A=

B>

C<

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using > instead of < for sales filters wrong rows.

Using != excludes the region instead of including it.

Use = to match "West" region and < to find sales less than 300.

5fill in blank

hard

Fill all three blanks to filter data where product is "Gadget", region is not "North", and sales are at least 400.

Google Sheets

=FILTER(A2:D100, C2:C100 [1] "Gadget", B2:B100 [2] "North", D2:D100 [3] 400)

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

A=

B!=

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using = instead of != excludes wrong regions.

Using > instead of >= misses sales exactly 400.

Use = for product match, != to exclude "North" region, and >= for sales at least 400.