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

Line charts connect data points across time intervals to show trends.

Question 2

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

Accepted Answer

Hierarchical data with many categories

Answer

Treemaps use nested rectangles to show hierarchy and proportion with many categories.

Question 3

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

Accepted Answer

Space between bars or columns

Answer

Gap Width controls spacing between bars, expressed as a percentage of bar width.

Question 4

What is a box and whisker chart used for?

Accepted Answer

Statistical distribution showing median, quartiles, and outliers

Answer

Box plots display five-number summaries: min, Q1, median, Q3, max, plus outliers.

Question 5

How do you create in-cell data bars?

Accepted Answer

Home > Conditional Formatting > Data Bars

Answer

Data Bars are a conditional formatting option that adds proportional bars inside cells.

Excel Practice Test