Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet.What should she do before creating the PivotChart?
A) Select the range where the PivotChart should be inserted.
B) Collapse the PivotTable fields to make room for the PivotChart.
C) Select a cell in the PivotTable.
D) Apply a PivotTable style so the PivotChart uses the same one.

Question

Quizplus · Accepted Answer

Before creating a PivotChart, Ingrid should select a cell in the PivotTable. This ensures that the PivotChart is based on the correct data and fields in the PivotTable. Selecting the range for the PivotChart, collapsing fields, or applying a PivotTable style are not necessary steps before creating the PivotChart.

Ingrid Wants to Create a PivotChart Based on a PivotTable