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.
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