Visualizing Data with Charts Answers

5 verified answers

How will Excel summarize the data to create PivotTables?

summarize by row but not by column

summarize by column but not by row

summarize by individual cells

summarize by row and by column

What is the definition of transactional data in Excel?

All cells have values and formulas.

Single cells have formulas and results.

Single cells have values but not formulas.

Multiple cells have header rows.

What is a PivotTable?

a chart that visualizes the data in a table

an image that symbolizes the result of a calculation

a table of source data that can be exported to other programs

an interactive table that summarizes and organizes data

How are PivotCharts different from regular charts?

They are interactive.

They contain images.

They have more color options.

They contain styles.

What is the first step needed before you can add a timeline to a PivotTable?

Click Insert Timeline.

Select the PivotTable.

Click Insert on the ribbon.

Click the Design contextual tab.

Did you find these answers helpful?

More from this Course