MOS - Microsoft Office Specialist Excel: Managing Worksheets & Workbooks Questions and Answers

Question 1

A user is working with a large dataset and wants to view the column headers in row 1 and the record identifiers in column A simultaneously, even when scrolling deep into the worksheet.
Which Excel feature allows for this type of view?

Accepted Answer

Freeze Panes

Answer

Split

Answer

New Window

Answer

Arrange All

Question 2

You have created a standardized budget workbook that your team will use as a starting point for all new projects. To prevent accidental overwriting of the original file, you need to save it in a format that opens as a new, untitled copy each time. Which file type should you choose in the 'Save As' dialog box?

Accepted Answer

Excel Template (.xltx)

Answer

Excel Workbook (.xlsx)

Answer

Excel Macro-Enabled Workbook (.xlsm)

Answer

Excel Binary Workbook (.xlsb)

Question 3

A project manager needs to compare sales data from two different workbooks simultaneously. What is the most efficient way to display both workbooks on the screen side-by-side for comparison?

Accepted Answer

Open both workbooks and use the 'Arrange All' command on the View tab.

Answer

Copy and paste the data from one workbook into a new sheet in the other.

Answer

Use the 'New Window' command on the View tab for each workbook.

Answer

Use the 'Switch Windows' command to toggle back and forth quickly.

Question 4

To prevent other users from adding, deleting, renaming, or hiding worksheets in a shared workbook, which protection option should be applied?

Accepted Answer

Protect Workbook Structure

Answer

Protect Sheet

Answer

Encrypt with Password

Answer

Mark as Final

Question 5

A financial analyst needs to display a summary total from a cell in a 'Source.xlsx' workbook within a cell in a 'Report.xlsx' workbook. The value in 'Report.xlsx' must update automatically whenever the data in 'Source.xlsx' changes. Which of the following methods creates this dynamic link?

Accepted Answer

In the 'Report' workbook, type '=' in a cell, navigate to the 'Source' workbook, click the desired cell, and press Enter.

Answer

In the 'Report' workbook, copy the desired cell from the 'Source' workbook and use the Paste Special > 'Values' option.

Answer

Use the Data > 'From File' > 'From Workbook' feature to import the entire worksheet.

Answer

In the 'Report' workbook, use the Insert > 'Object' command and select the 'Source' workbook.

Question 6

While analyzing a large worksheet, a user wants to view four different sections of the same sheet at once, scrolling independently in each section. Which command on the 'View' tab should be used to achieve this?

Accepted Answer

Split

Answer

Freeze Top Row

Answer

New Window

Answer

Arrange All