← All Microsoft Excel Flashcard Decks

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
  1. What does the Transpose paste option do?

    Answer: Switches rows and columns

    Transpose switches orientation — rows become columns and vice versa.

  2. How does Remove Duplicates work?

    Answer: Permanently deletes duplicate rows, keeping first occurrence

    Remove Duplicates permanently deletes rows with duplicate values in selected columns.

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

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

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

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

  1. store.certiport.com — Fees, retake fee · verified Nov 2026
  2. certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
  3. learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026