Microsoft Excel Workbook and Worksheet Management 2 — Questions and Answers
Question 1: What file formats can Excel save workbooks in?
- Only .xlsx
- Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more (Correct answer)
- Only .xlsx and .csv
- Only Microsoft formats
Correct answer: Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more
Excel supports many formats including .xlsx, .xlsm, .xlsb, .csv, .pdf, .html, .xml, .ods.
.xlsb recommended for large workbooks (50%+ smaller). .csv loses formatting, formulas, multiple sheets. .xlsm required for macros.
Question 2: How does AutoSave work in Excel?
- Always available for all files
- Saves in real-time for files on OneDrive, SharePoint, or Teams (Correct answer)
- Saves locally every 5 minutes
- Paid add-on
Correct answer: Saves in real-time for files on OneDrive, SharePoint, or Teams
AutoSave continuously saves for cloud-stored files, enabling collaboration and version history.
Different from AutoRecover (backup copies at intervals for local files). AutoSave enables co-authoring and version history.
Question 3: What is Page Layout View?
- Creates a new page
- Shows how worksheet looks when printed with headers, footers, margins (Correct answer)
- Arranges cells in page format
- Converts to Word layout
Correct answer: Shows how worksheet looks when printed with headers, footers, margins
Page Layout View displays the worksheet as it will appear when printed.
Shows draggable margins, editable headers/footers, page breaks, whitespace between pages.
Question 4: How do you hide worksheets?
- Delete key on tab
- Right-click tab > Hide; right-click any tab > Unhide to restore (Correct answer)
- Cannot be hidden
- Ctrl+H toggles visibility
Correct answer: Right-click tab > Hide; right-click any tab > Unhide to restore
Right-click tab > Hide removes visibility; Unhide restores it.
Very Hidden (VBA only) doesn't appear in Unhide dialog. At least one sheet must remain visible. Formulas still reference hidden sheets.
Question 5: What does Print Titles do?
- Adds title page
- Repeats specified rows/columns on every printed page (Correct answer)
- Changes title font
- Prints only title cells
Correct answer: Repeats specified rows/columns on every printed page
Print Titles repeats header rows and label columns on every printed page.
Page Layout > Print Titles. Set rows to repeat at top and columns at left. Differs from Freeze Panes (screen only).
Question 6: How do you compare two worksheets side by side?
- Compare button in File
- View > View Side by Side with optional synchronized scrolling (Correct answer)
- Right-click tab > Compare
- Not possible
Correct answer: View > View Side by Side with optional synchronized scrolling
View Side by Side tiles two windows and can synchronize scrolling.
For same workbook: View > New Window first. Inquire add-in provides cell-by-cell comparison with highlighted differences.
Microsoft Excel Workbook and Worksheet Management 2
What file formats can Excel save workbooks in?