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.