Microsoft Excel Excel Pivot Charts 2

Question 1

Which tool lets you add clickable buttons that filter both a PivotTable and its PivotChart at the same time?

Accepted Answer

Slicer

Answer

Slicers provide visual filters connected to one or more PivotTables and their charts.

Question 2

To display Sales by Region as separate lines over Month on a PivotChart, where should the Region field be placed?

Accepted Answer

Legend (Series)

Answer

Each series in a chart comes from the Legend area, which maps to Columns.

Question 3

Which feature adds interactive date-based filtering with a draggable time range to a PivotChart?

Accepted Answer

Timeline

Answer

A Timeline slicer filters PivotTables and PivotCharts by date periods.

Question 4

New records were added to the source table of a PivotChart, but the chart has not changed. What should you do?

Accepted Answer

Click Refresh on the PivotChart Analyze tab

Answer

PivotCharts do not update until the PivotTable cache is refreshed.

Question 5

Which option in PivotTable Options makes a PivotChart automatically reflect changes when the workbook is opened?

Accepted Answer

Refresh data when opening the file

Answer

This setting on the Data tab of PivotTable Options refreshes the cache at file open.

Excel Practice Test