To Summarize and Analyze Data with Both a Crosstabulation and Charting

question 59

Multiple Choice

To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs

• A) PivotCharts with PivotTables.
• B) stacked column charts with PivotTables.
• C) heat maps with trendline.
• D) bubble chart with trendline.

---

Definitions:

Supply Conditions

Factors that affect the quantity of a good or service that producers are willing and able to sell at a given price.

Excise Tax

A tax on the manufacture, sale, or consumption of certain goods and services within a country.

Tax Burden

The measure of the total amount of taxes paid by individuals or businesses, often expressed as a percentage of income or GDP.

Equilibrium

A state where market supply and demand balance each other, and as a result, prices become stable.