PivotTables and PivotCharts Flashcards
7 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 7 PivotTables and PivotCharts flashcards as text
What is the GETPIVOTDATA function used for?
Answer: To retrieve a specific value from a PivotTable using field and item names
GETPIVOTDATA extracts a specific value from a PivotTable by specifying the data field, PivotTable reference, and field/item label pairs.
What is a Timeline filter in Excel PivotTables?
Answer: A visual date filter control that lets you filter PivotTable data by dragging across time periods
A Timeline is a visual date-filtering control that lets users filter PivotTable data interactively by selecting specific months, quarters, or years on a sliding timeline bar.
How do you prevent a PivotTable's column widths from automatically resizing every time it is refreshed?
Answer: Uncheck 'Autofit column widths on update' in PivotTable Options
In PivotTable Options under the Layout & Format tab, unchecking 'Autofit column widths on update' stops Excel from resizing columns on refresh.
Which of the following correctly describes Grand Totals in a PivotTable?
Answer: Summary values at the bottom row and/or rightmost column that aggregate all data
Grand Totals are overall summary rows and/or columns at the edges of the PivotTable that sum or aggregate all values across every row or column.
What does 'Value Field Settings' allow you to configure for a PivotTable Values field?
Answer: The display name, summary function (Sum/Count/Average), and number format
Value Field Settings lets you change the aggregation function and apply number formatting for a specific field in the Values area.
When a PivotTable is filtered using a Slicer, what happens to its associated PivotChart?
Answer: The PivotChart is automatically updated to reflect the filtered data
PivotCharts are dynamically linked to their PivotTable, so any filter changes are immediately and automatically reflected in the chart.
What is the purpose of grouping items in a PivotTable?
Answer: To organize items into custom categories or time periods for more meaningful analysis
Grouping lets you combine related items (such as months into quarters, or numeric ranges into buckets) to make the PivotTable easier to analyze.