Managing Tables and Data 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 Managing Tables and Data flashcards as text
What is a PivotTable's primary purpose?
Answer: Summarizes large datasets by dragging fields into rows, columns, values, and filters
PivotTables provide drag-and-drop data summarization for large datasets.
How do you refresh a PivotTable after source data changes?
Answer: Right-click > Refresh, or PivotTable Analyze > Refresh
PivotTables require manual refresh via right-click or the Refresh button.
What does the Consolidate feature do?
Answer: Combines data from multiple ranges into one summary using aggregate functions
Consolidate combines data from multiple ranges across sheets using SUM, AVERAGE, etc.
What does 'Show Values As' do in a PivotTable?
Answer: Changes calculation display: percentage of total, running total, rank, etc.
Show Values As transforms how values are presented without modifying source data.
How does Power Query help with data preparation?
Answer: Imports, cleans, transforms data from various sources with a visual step editor
Power Query provides a visual editor for importing and transforming data with recordable, repeatable steps.
What is the difference between Group and Ungroup in PivotTables?
Answer: Group combines items into categories, Ungroup reverts to individual items
Group combines items into custom categories; Ungroup reverses this.