Free Preparation Discussions
MENU
Microsoft Exam 77-427 Topic 7 Question 27 Discussion
Topic #: 7
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. 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?
According to the question, you have to remove all subtotals from the worksheet with the least administrative effort. You can remove all subtotals from a worksheet at a time. For this, take the following steps: Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab.
Click the Remove All option.
Answer option A is incorrect. No such option is provided in Excel 2013.
Answer option B is incorrect. Although this will hide the rows containing the subtotals, the contents will remain there and can be made visible by using the Unhide row option. Moreover, the question specifically specifies to remove all subtotals from the sheet. Answer option D is incorrect. Although this step will accomplish the task, it will involve a lot of administrative burden of selecting each row and deleting it manually.
Currently there are no comments in this discussion, be the first to comment!