Page 9 of 10PREVNEXT

PivotTable II: Filter PivotTable report data in Excel 2007

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You can see if a filter has been applied to a field.

True.

False.

You have two filters applied. You want to clear one filter. But the Clear Filter From command is not available, so you:

Can't undo the filter and have to create the PivotTable report over again.

On the Ribbon Options tab, in the Actions group, click the arrow on the Clear button, and then click Clear Filters.

Click the arrow next to the filter icon on Row Labels or Column Labels. In the Select field box, click another field name.

You can clear a filter by clicking in the PivotTable Field List.

True.

False.

The only way to add filters is by clicking the arrow next to Row Labels or Column Labels.

True.

False.

In the practice you added a report filter to a PivotTable report. That filter is used to:

Hide all numeric data.

Show a subset of data, usually a product line, a time span, or a geographic region.

Hide the subtotals and grand totals in a PivotTable report.

You have dates in your PivotTable report, but when you try to apply a filter, the Date Filters command doesn't appear. What do you think might be the problem?

You might be clicking in the wrong area of the report to see the command.

The dates aren't properly formatted as dates.

Both options.

Page 9 of 10PREVNEXT