Câu 20: 77-602: MOS: Using Microsoft Office Excel 2007

You work as a Sales Manager for Peach Tree Inc. You have created a report in a workbook in Excel 2007. The segment of a worksheet in the report is shown in the image given below: The list includes Zones and Months columns. You want to summarize sales data on the basis of these columns. Which of the following steps will you take to accomplish the task with least administrative burden?

1. A. Select the list.Click the Create from Selection option in the Defined Names group on the Formulas tab.
2. B. Click the Consolidate option in the Data Tools group on the Data tab.
3. C. Add subtotal rows manually at the required places.
4. D. Use the outline feature. — đáp án hiện tại