Excel Pivot Charts Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Excel Pivot Charts flashcards as text
Which tool lets you add clickable buttons that filter both a PivotTable and its PivotChart at the same time?
Answer: Slicer
Slicers provide visual filters connected to one or more PivotTables and their charts.
To display Sales by Region as separate lines over Month on a PivotChart, where should the Region field be placed?
Answer: Legend (Series)
Each series in a chart comes from the Legend area, which maps to Columns.
Which feature adds interactive date-based filtering with a draggable time range to a PivotChart?
Answer: Timeline
A Timeline slicer filters PivotTables and PivotCharts by date periods.
New records were added to the source table of a PivotChart, but the chart has not changed. What should you do?
Answer: Click Refresh on the PivotChart Analyze tab
PivotCharts do not update until the PivotTable cache is refreshed.
Which option in PivotTable Options makes a PivotChart automatically reflect changes when the workbook is opened?
Answer: Refresh data when opening the file
This setting on the Data tab of PivotTable Options refreshes the cache at file open.
You want to show only the five best-selling products on a PivotChart. Which filter should you apply to the Product field?
Answer: Value Filter > Top 10 set to 5 items
Top 10 value filters can be adjusted to any number of items by sum of a value field.