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

Line chart

Answer

Scatter plot

Answer

Histogram

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

Use the Insert menu

Answer

Double-click the chart title

Answer

Not supported in Excel

Question 3

What is a sparkline in Excel?

Accepted Answer

A tiny chart within a single cell showing data trends

Answer

A type of conditional formatting

Answer

An animated chart effect

Answer

A chart template

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

Type the cell reference in the title

Answer

Use a macro

Answer

Not possible in Excel

Question 5

What is the purpose of error bars in charts?

Accepted Answer

Displaying variability or uncertainty of data points

Answer

Highlighting incorrect data

Answer

Showing when data exceeds boundaries

Answer

Indicating formula errors

Question 6

Which chart shows the relationship between two numerical variables?

Accepted Answer

Scatter (XY) chart

Answer

Bar chart

Answer

Pie chart

Answer

Area chart