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:

Information

Data, facts, or knowledge provided or learned about something or someone.

Reader-centred

Writing or presenting information in a way that focuses on and meets the needs and interests of the reader.

Concise

Communicating in a clear and brief manner, without unnecessary detail or verbosity.

Organizational Patterns

The structures used to arrange or classify information, ideas, or items in writing or speeches, such as chronological or cause-and-effect.