To Summarize and Analyze Data with Both a Crosstabulation and Charting

question 27

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 trendlines.
• D)bubble charts with trendlines.

---

Definitions:

NAEP

The National Assessment of Educational Progress, which evaluates the knowledge and skills of American students in various subjects.

National Report Card

A metaphorical term used to grade the education system of a nation on various academic and qualitative criteria.

Diagnostic Tests

Tests designed to determine the presence of a disease, condition, or specific trait through evaluation of physical condition, laboratory analysis, or other means.

Intelligence Tests

Standardized assessments designed to evaluate cognitive functions and intellectual abilities of individuals.