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