Managing Tables and Table 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 Table Data flashcards as text
How do calculated columns work in Excel Tables?
Answer: A formula in one cell automatically fills the entire column
Formulas auto-propagate through the entire Table column using structured references.
How do structured references differ from cell references?
Answer: Use table and column names like Table1[@Sales] instead of B2
Structured references use descriptive names making formulas readable and resilient to changes.
What does Resize Table do?
Answer: Adjusts table boundaries to include more or fewer rows/columns
Resize Table modifies the table range to include or exclude rows and columns.
What does Convert to Range do?
Answer: Removes Table functionality while preserving data and formatting
Convert to Range removes all Table features but keeps cell data and visual formatting.
How do Table column filter dropdowns work?
Answer: Click header dropdown for sort, text/number filters, and checkbox selection
Each column header has a dropdown with sorting, value selection, and advanced filters.
What is the Table Name used for?
Answer: Unique identifier used in structured references and formulas
Table Name is used in structured references and can be renamed in Table Design tab.
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