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 happens when you convert a range to an Excel Table (Ctrl+T)?
Answer: Gains structured references, auto-filters, formatting, and dynamic expansion
Tables add auto-filters, structured references, automatic formatting, and auto-expansion.
How does multi-level sorting work in Excel?
Answer: Each level sorts within groups created by the previous level
Multi-level sorting creates a hierarchy: first level sorts all data, subsequent levels sort within groups.
What is the Total Row in an Excel Table?
Answer: A summary row with dropdown aggregate functions for each column
Total Row adds summary functions (SUM, AVERAGE, COUNT, etc.) at the bottom of each column.
How does Advanced Filter differ from AutoFilter?
Answer: Can extract to another location, use complex AND/OR criteria, find unique records
Advanced Filter supports complex multi-field AND/OR criteria, copying results elsewhere, and unique records.
What are Slicers for Tables?
Answer: Visual filter buttons for interactive single-click filtering
Slicers provide clickable buttons that instantly filter Table data.
How does SUBTOTAL differ from regular aggregate functions?
Answer: Ignores hidden/filtered rows and supports 11 different functions
SUBTOTAL can ignore hidden rows, filtered rows, and nested SUBTOTAL results.