Câu 7: 77-888: Excel 2010 Expert

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?

1. A. Select all the subtotals. From the shortcut menu, click the Remove All Subtotals option.
2. B. Hide the rows containing subtotals.
3. C. Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab. Click the Remove All button. — đáp án hiện tại
4. D. Delete all the rows containing subtotals.