Filtering PivotTable data in Excel - 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 information you want to see, making analysis easier and clearer.

beginner

How do you apply a filter to a PivotTable field in Excel?

Click the drop-down arrow next to the field name in the PivotTable, then check or uncheck the items you want to show or hide, and click OK.

intermediate

What is a Slicer in Excel PivotTables?

A Slicer is a visual filter tool that lets you click buttons to filter PivotTable data quickly and clearly, making it easy to see what filters are applied.

intermediate

Can you filter multiple fields in a PivotTable at the same time?

Yes, you can apply filters to multiple fields simultaneously to narrow down your data from different angles for more detailed analysis.

beginner

What happens if you clear all filters in a PivotTable?

Clearing all filters will show all the data again in the PivotTable, removing any restrictions and displaying the full dataset.

How do you open the filter menu for a PivotTable field?

A Click the drop-down arrow next to the field name

B Double-click any cell in the PivotTable

C Right-click the worksheet tab

D Press Ctrl + F

The filter menu appears when you click the drop-down arrow next to the field name in the PivotTable.

What is the main advantage of using a Slicer in a PivotTable?

A It creates charts automatically

B It sorts data alphabetically

C It provides a visual and easy way to filter data

D It exports data to another file

Slicers let you filter PivotTable data visually by clicking buttons, making filtering easier and clearer.

Which of these can you NOT do with PivotTable filters?

A Filter by color of cells outside the PivotTable

B Filter by date ranges

C Filter by specific items

D Filter by top or bottom values

PivotTable filters work on the data inside the PivotTable, not on cell colors outside it.

If you want to see all data again after filtering, what should you do?

A Apply more filters

B Refresh the worksheet

C Delete the PivotTable

D Clear all filters

Clearing all filters removes restrictions and shows all data in the PivotTable.

Can you filter more than one field in a PivotTable at the same time?

A No, only one field can be filtered

B Yes, multiple fields can be filtered simultaneously

C Only if you use a Slicer

D Only if the PivotTable is connected to an external data source

You can apply filters to multiple fields at once to narrow down data from different perspectives.

Explain how to filter data in a PivotTable and why it is useful.

Think about how filtering helps you see only what you want.

Describe what a Slicer is and how it improves filtering in PivotTables.

Imagine a set of buttons that filter your data visually.