Microsoft Excel Creating and Managing Charts 2

Question 1

Which chart type best shows composition of a whole at a single point in time?

Accepted Answer

Pie chart

Answer

Pie charts show how parts contribute to a whole using proportional slices.

Question 2

How do you add a secondary axis to an Excel chart?

Accepted Answer

Right-click data series, Format Data Series, choose Secondary Axis

Answer

Right-click the data series, choose Format Data Series, and select Secondary Axis.

Question 3

What is a sparkline in Excel?

Accepted Answer

A tiny chart within a single cell showing data trends

Answer

Sparklines are miniature charts that fit inside a single cell.

Question 4

How do you create a dynamic chart title linked to a cell?

Accepted Answer

Click the title, click formula bar, type = and click the cell

Answer

Click the chart title, then use the formula bar to link it to a cell reference.

Question 5

What is the purpose of error bars in charts?

Accepted Answer

Displaying variability or uncertainty of data points

Answer

Error bars represent variability, uncertainty, or margin of error in data.

Excel Practice Test