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