Microsoft Excel Data Visualization with Charts 2

Question 1

What chart type is best for showing trends over continuous time?

Accepted Answer

Line chart

Answer

Pie chart

Answer

Treemap

Answer

Doughnut chart

Question 2

When should you use a treemap instead of a pie chart?

Accepted Answer

Hierarchical data with many categories

Answer

Data has negative values

Answer

Comparing exactly two values

Answer

Time-based trends

Question 3

What does the 'Gap Width' setting control in bar/column charts?

Accepted Answer

Space between bars or columns

Answer

Space between chart and border

Answer

Width of the legend

Answer

Distance between axis labels

Question 4

What is a box and whisker chart used for?

Accepted Answer

Statistical distribution showing median, quartiles, and outliers

Answer

Stock price open/high/low/close

Answer

Decorative chart borders

Answer

Minimum and maximum only

Question 5

How do you create in-cell data bars?

Accepted Answer

Home > Conditional Formatting > Data Bars

Answer

Insert > Charts > Data Bar

Answer

Format Cells > Data Bars

Answer

View > Data Bar toggle

Question 6

What visualization shows distribution of a single continuous variable?

Accepted Answer

Histogram

Answer

Scatter chart

Answer

Radar chart

Answer

Bubble chart