Question

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

a. heat maps with a trendline.
b. PivotCharts with PivotTables.
c. stacked column charts with PivotTables.
d. bubble chart with a trendline.

Answer 1

To summarize and analyze data with both a crosstabulation and charting, Excel typically pair PivotCharts with PivotTables (option b)

Step-by-step explanation:

Pivot Tables allows us to deal with a high volume of data. This kind of tables are mainly designed to summarize, analyze and explore data in a simple way. Meanwhile, Pivot Charts gives the possibility to visualize the summarizing data provided in PivotTables, enabling the detection of trends, correlations,comparisons and so on. Because of that Pivot tables and pivot charts are usefull and complementary tools of Excel.

Summarizing, the proper option is b.