Microsoft Excel 2010 Expert — Question 3

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the following actions will Rick take to accomplish the task?

Answer options

• A. He will use stand-alone slicers.
• B. He will create a PivotTable report.
• C. He will configure form controls.
• D. He will create a PivotChart report.

Correct answer: D

Explanation

The correct answer is D, as creating a PivotChart report allows Rick to visually represent data series, categories, data markers, and axes effectively. While a PivotTable report (B) can summarize data, it does not provide the visual representation that a PivotChart offers. Options A and C do not relate to the requirement of displaying data in a chart format.