Microsoft Excel 2010 Expert — Question 7

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. You have included various subtotals in a worksheet in the report to verify data accuracy. You want to remove all subtotals from the sheet before you send it to your manager.
Which of the following steps will you take to accomplish the task with the least administrative effort?

Answer options

• A. Select all the subtotals. From the shortcut menu, click the Remove All Subtotals option.
• B. Hide the rows containing subtotals.
• C. Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab. Click the Remove All button.
• D. Delete all the rows containing subtotals.

Correct answer: C

Explanation

The correct answer is C because accessing the Subtotal dialog box allows you to efficiently remove all subtotals in one action. Option A is incorrect as it does not exist in Excel 2010, while B and D are not efficient methods as they involve either hiding or deleting rows, which is more labor-intensive.