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.