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 you create a PivotTable from an Excel Table?
Answer: Click in Table, Insert > PivotTable — Table name auto-used as source
Excel uses the Table name as source, so new rows are included on Refresh.
What does Banded Rows do in Table Styles?
Answer: Alternates row shading for readability
Banded Rows alternates background colors to visually separate adjacent rows.
How does AutoComplete differ in Tables vs regular ranges?
Answer: Tables offer column name suggestions when typing [ in formulas
Tables show structured reference column names when typing [ after the table name.
What is the blue resize handle at Table's bottom-right corner?
Answer: Drag to expand or contract the Table range
The blue triangle can be dragged to manually include or exclude rows and columns.
How do you export a Table to SharePoint?
Answer: Table Design > Export > Export Table to SharePoint List
Excel provides built-in export that publishes Table structure and data to SharePoint.
What happens to formulas when you rename a Table?
Answer: Excel auto-updates all structured references to the new name
Renaming auto-updates all structured references throughout the workbook.
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