Microsoft Excel Workbook and Worksheet Management 2

Question 1

What file formats can Excel save workbooks in?

Accepted Answer

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

Answer

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

Question 2

How does AutoSave work in Excel?

Accepted Answer

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

Answer

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

Question 3

What is Page Layout View?

Accepted Answer

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

Answer

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

Question 4

How do you hide worksheets?

Accepted Answer

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

Answer

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

Question 5

What does Print Titles do?

Accepted Answer

Repeats specified rows/columns on every printed page

Answer

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

Excel Practice Test