Ingrid Wants to Create a PivotChart Based on a PivotTable

question 321

Multiple Choice

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.

---

Definitions:

Excise Tax

A tax levied on specific goods, services, or transactions, such as alcohol, tobacco, and gasoline, often intended to discourage their use or generate revenue.

SUVs

Sport Utility Vehicles; a category of large vehicles that are designed for off-road use or have capabilities for off-road use but are often used as family cars.

Downward-Sloping

A characteristic of demand curves in economics, indicating that demand decreases as the price increases.

FICA Tax

A U.S. federal payroll tax that funds Social Security and Medicare, required to be paid by both employees and employers.