Excel Ch 3

Which chart type is preferable when the category names are long?

Bar

Which axis in a chart displays the descriptive labels for the data points?

Category

What is not true about an effective chart?

It always contains more than one series.

Which axis in a chart displays incremental numbers for the data points?

Value

What should you not select when selecting data for a chart?

Worksheet titles

Where does Excel display the Quick Analysis tool?

bottom right corner

Which of the following is not a chart type?

circle

Which of the following is not a chart element?

data area

Which tab displays the tools for creating charts?

insert

Including what, distorts the effectiveness of charting data points?

Aggregates

How many variations of the stock chart does Excel have?

4

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

Pie

What is not a purpose of using an effective chart?

Reveals even subtle errors in formulas

What is a disadvantage of a stacked column chart?

Segments do not start at the same point

What chart type is not listed in the All Charts window?

Sparkline