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

Only .xlsx

Answer

Only .xlsx and .csv

Answer

Only Microsoft formats

Question 2

How does AutoSave work in Excel?

Accepted Answer

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

Answer

Always available for all files

Answer

Saves locally every 5 minutes

Answer

Paid add-on

Question 3

What is Page Layout View?

Accepted Answer

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

Answer

Creates a new page

Answer

Arranges cells in page format

Answer

Converts to Word layout

Question 4

How do you hide worksheets?

Accepted Answer

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

Answer

Delete key on tab

Answer

Cannot be hidden

Answer

Ctrl+H toggles visibility

Question 5

What does Print Titles do?

Accepted Answer

Repeats specified rows/columns on every printed page

Answer

Adds title page

Answer

Changes title font

Answer

Prints only title cells

Question 6

How do you compare two worksheets side by side?

Accepted Answer

View > View Side by Side with optional synchronized scrolling

Answer

Compare button in File

Answer

Right-click tab > Compare

Answer

Not possible