MOS Excel: Managing Worksheets & Workbooks 2

Question 1

You want to move a worksheet to the last position in a workbook with 5 sheets. What is the fastest method?

Accepted Answer

Drag the sheet tab to the right of all other tabs

Answer

Dragging a sheet tab to the desired position is the fastest way to reorder worksheets in Excel.

Question 2

Which keyboard shortcut cycles through all open workbooks in Excel?

Accepted Answer

Ctrl+F6

Answer

Ctrl+F6 cycles between open Excel workbook windows.

Question 3

A workbook has a sheet named 'Sales'. You create a copy and both exist in the same workbook. What does Excel name the copy?

Accepted Answer

Sales (2)

Answer

Excel names the copied sheet 'Sales (2)' with a space before the parenthesis.

Question 4

You want to prevent users from inserting or deleting worksheets in a workbook. Which option achieves this?

Accepted Answer

Workbook structure protection via Review > Protect Workbook

Answer

Protecting the workbook structure via Review > Protect Workbook prevents users from adding, deleting, or moving sheets.

Question 5

How do you select every worksheet in a workbook simultaneously?

Accepted Answer

Right-click a tab and choose 'Select All Sheets'

Answer

Right-clicking any sheet tab and choosing 'Select All Sheets' groups all worksheets together.

MOS - Microsoft Office Specialist Certification Practice Test