← All Microsoft Excel Flashcard Decks

Workbook and Worksheet Management 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 Workbook and Worksheet Management flashcards as text
  1. What file formats can Excel save workbooks in?

    Answer: Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more

    Excel supports many formats including .xlsx, .xlsm, .xlsb, .csv, .pdf, .html, .xml, .ods.

  2. How does AutoSave work in Excel?

    Answer: Saves in real-time for files on OneDrive, SharePoint, or Teams

    AutoSave continuously saves for cloud-stored files, enabling collaboration and version history.

  3. What is Page Layout View?

    Answer: Shows how worksheet looks when printed with headers, footers, margins

    Page Layout View displays the worksheet as it will appear when printed.

  4. How do you hide worksheets?

    Answer: Right-click tab > Hide; right-click any tab > Unhide to restore

    Right-click tab > Hide removes visibility; Unhide restores it.

  5. What does Print Titles do?

    Answer: Repeats specified rows/columns on every printed page

    Print Titles repeats header rows and label columns on every printed page.

  6. How do you compare two worksheets side by side?

    Answer: View > View Side by Side with optional synchronized scrolling

    View Side by Side tiles two windows and can synchronize scrolling.

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