Microsoft Excel Workbook and Worksheet Management Questions and Answers

Question 1

A user wants to apply the same page layout settings to multiple worksheets simultaneously in an Excel workbook. Which of the following is the most efficient method to achieve this?

Accepted Answer

Group the desired worksheets together before applying the settings.

Answer

Grouping worksheets allows you to make changes to all selected sheets at the same time. Any formatting or layout changes made to the active sheet while they are grouped will be applied to all other sheets in the group, which is highly efficient.

Question 2

You are creating a quarterly sales report that has a large amount of data. To analyze the figures effectively, you need to see the column headers in the first row and the salesperson's name in the first column at all times, even when scrolling down or across the worksheet. Which Excel feature should you use?

Accepted Answer

Freeze Panes

Answer

The Freeze Panes feature is specifically designed to lock specific rows and columns in place, making them visible while you scroll through the rest of the worksheet. Splitting the window creates separate scrollable panes but doesn't lock headers in the same way.

Question 3

Which of the following actions is prevented when you use the 'Protect Workbook' feature with the 'Structure' option selected?

Accepted Answer

Adding a new worksheet

Answer

Protecting a workbook's structure specifically prevents users from making changes to the workbook's layout, which includes adding, deleting, renaming, moving, hiding, or unhiding worksheets. Protecting the worksheet, not the workbook, controls cell editing and formatting.

Question 4

A project manager has created a detailed project plan in an Excel workbook. They want to save this workbook as a reusable file that contains all the formatting, formulas, and layouts, which can be used as a starting point for future projects without altering the original plan. How should they save the file?

Accepted Answer

As an Excel Template (.xltx)

Answer

Saving a workbook as an Excel Template (.xltx) creates a master copy. When a user opens a template file, Excel creates a new, unsaved workbook based on the template, leaving the original template file untouched. This is the standard method for creating reusable workbook structures.

Question 5

To compare data from two different worksheets within the same workbook side-by-side, which sequence of commands on the 'View' tab is correct?

Accepted Answer

New Window > Arrange All > Vertical

Answer

To view two sheets from the same workbook, you first need to open a second window of the current workbook using 'New Window'. Then, you can use 'Arrange All' and select an option like 'Vertical' to display both windows (and thus, different sheets) side-by-side.

Excel Practice Test

Excel Practice Test

Microsoft Excel Workbook and Worksheet Management Questions and Answers