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

Copy and paste the settings from one worksheet to another.

Answer

Manually apply the settings to each worksheet individually.

Answer

Record a macro to apply the settings and run it on each sheet.

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

Split

Answer

New Window

Answer

Arrange All

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

Editing cell contents

Answer

Changing the font color of data

Answer

Formatting cell borders

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

As an Excel Workbook (.xlsx)

Answer

As a PDF (.pdf)

Answer

As a Macro-Enabled Workbook (.xlsm)

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

Arrange All > Vertical

Answer

Split > Arrange All

Answer

Freeze Panes > View Side-by-Side

Question 6

A user wants to split their worksheet into four panes to view different sections of their data simultaneously. Where must the user click before selecting the 'Split' command from the 'View' tab to achieve this?

Accepted Answer

The cell where they want the top-left corner of the bottom-right pane to be

Answer

Any cell in column A

Answer

Any cell in row 1

Answer

The Home tab