Filtering PivotTable data in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of filtering data in a PivotTable?

Filtering in a PivotTable helps you focus on specific parts of your data by showing only the rows or columns you want to see. It makes large data easier to understand.

beginner

How do you add a filter to a PivotTable in Google Sheets?

You click on the PivotTable, then in the editor panel, use the 'Filters' section to add a field. After adding, you choose which items to show or hide.

beginner

True or False: Filtering a PivotTable changes the original data in your spreadsheet.

False. Filtering only changes what you see in the PivotTable. The original data stays the same.

intermediate

What is a 'Report Filter' in a PivotTable?

A Report Filter lets you filter the entire PivotTable by one field. For example, you can show data for only one region or one product at a time.

intermediate

How can you filter PivotTable data by condition (like values greater than 100)?

In Google Sheets, you can use the 'Filter by condition' option in the filter settings of the PivotTable to show only data that meets your condition, such as values greater than 100.

Where do you add a filter in a Google Sheets PivotTable?

A In the 'Values' section of the PivotTable editor

B By changing the original data cells

C In the 'Filters' section of the PivotTable editor

D By deleting rows in the spreadsheet

Filters are added in the 'Filters' section of the PivotTable editor to control which data is shown.

What happens to the original data when you filter a PivotTable?

A It stays the same

B It gets deleted

C It changes permanently

D It moves to another sheet

Filtering only changes the view in the PivotTable, not the original data.

Which filter type lets you filter the whole PivotTable by one field?

A Value filter

B Column filter

C Row filter

D Report filter

Report filter applies to the entire PivotTable based on one field.

How can you filter PivotTable data to show only sales greater than 500?

A Use 'Filter by condition' with 'Greater than 500'

B Manually delete rows with sales less than 500

C Change the original data

D Use 'Sort' instead of filter

The 'Filter by condition' option allows filtering data based on numeric conditions.

If you want to see data for only one product in a PivotTable, what should you do?

A Use the 'Values' section to filter

B Add a filter for the product field and select that product

C Change the PivotTable layout

D Delete other products from the data

Adding a filter for the product field and selecting one product shows only that product's data.

Explain how to add and use a filter in a Google Sheets PivotTable.

Think about the steps you take after clicking on the PivotTable.

Describe the difference between filtering a PivotTable and changing the original data.

Consider what happens to your spreadsheet data when you apply a filter.