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 a PivotTable in Microsoft Excel?
Answer: An interactive tool that summarizes large data sets into a compact, organized format
A PivotTable is an interactive data summarization tool that reorganizes and aggregates large data sets for easier analysis.
Which tab in Excel's ribbon is used to insert a PivotTable?
Answer: Insert
PivotTables are inserted from the Insert tab by clicking the PivotTable button in the Tables group.
Which of the following is NOT one of the four field areas in the PivotTable Fields pane?
Answer: Headers
The four PivotTable field areas are Rows, Columns, Values, and Filters — Headers is not a PivotTable field area.
What default summary function does the Values area use for numeric fields in a PivotTable?
Answer: SUM
Excel defaults to SUM when a numeric field is placed in the Values area of a PivotTable.
What does refreshing a PivotTable do?
Answer: Updates the PivotTable to reflect changes in the source data
Refreshing updates the PivotTable to incorporate any additions, deletions, or changes made to the source data.
What is a Slicer in Microsoft Excel?
Answer: A visual filter control that provides clickable buttons for filtering PivotTable data
A Slicer is a visual filter control with clickable buttons that allows users to quickly filter PivotTable or Table data interactively.
What happens when you double-click a value cell in a PivotTable?
Answer: Excel drills down and creates a new sheet showing the underlying detail records
Double-clicking a value cell drills down to show the source records that make up that aggregated value on a new worksheet.