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.