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.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026