You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have
selected all worksheets available in the workbook as shown below:
Now, you want to cancel the selection. Which of the following steps will you take to accomplish the
task with least administrative effort?
A.
Click any unselected sheet.
B.
Click on one of the selected sheets.
C.
Double-click on one of the selected sheets.
D.
Click the Single Sheet options in the Sheet Options group on the Page Layout tab.
E.
Right-click the selected sheets.
Click the Ungroup Sheets option from the shortcut menu.
Explanation:
When multiple sheets are selected, Excel groups the sheet and the [Group] appears in the title bar as
shown below:To unselect the sheet, you are required to click any unselected sheet. However, the question states
that all sheets are selected. In such a case, in order to unselect the sheets, you will have to take the
following steps:
Right-click the selected sheets. Click the Ungroup Sheets option from the shortcut menu.
Answer C and B are incorrect. These options will not ungroup the sheets.
Answer A is incorrect. The question states that all sheets are selected. Hence, no unselected sheet
will be available.
Answer D is incorrect. No such option as Single Sheet is available in Excel.
