Managing Data Cells and Ranges 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 Data Cells and Ranges flashcards as text
What does the Transpose paste option do?
Answer: Switches rows and columns
Transpose switches orientation — rows become columns and vice versa.
How does Remove Duplicates work?
Answer: Permanently deletes duplicate rows, keeping first occurrence
Remove Duplicates permanently deletes rows with duplicate values in selected columns.
What is Data Validation used for?
Answer: Restricting data types and values that can be entered into cells
Data Validation creates rules controlling what users can enter.
What does the Fill Handle do?
Answer: Extends series, copies values, or applies patterns when dragged
Dragging the fill handle auto-fills adjacent cells by extending patterns or copying.
How does the Watch Window help with large spreadsheets?
Answer: Displays selected cells' values in a floating window visible while navigating
Watch Window shows cell values and formulas in a persistent panel across sheets.
What is Group and Outline used for?
Answer: Collapsing and expanding sections of rows or columns
Creates collapsible sections with +/- buttons for hiding or showing detail data.