Analyzing and Visualizing Data with Microsoft Excel — Question 70

You have a PivotChart template named Template1.
You add a PivotChart to a worksheet.
You need to apply the template to the PivotChart.
What should you do?

Answer options

• A. On the Format tab, click Format Selection
• B. Right-click the chart, and then click Format Chart Area
• C. On the Design tab, click Change Chart Type
• D. Right-click the chart, and then click PivotChart Options

Correct answer: C

Explanation

The correct answer is C because applying a template to a PivotChart is done through the Design tab where you can change the chart type to reflect the template. Options A and B deal with formatting but not template application, while D addresses PivotChart options, which do not directly apply a template.