Exam 8: Excell: Charts

In a(n) ________ column chart data appears as side by side columns.

A chart style effects the formatting of the chart itself, but not the chart data.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

Match the following terms with their description (since the options are very similar, pick the most complete, descriptive answer): i. Clustered column chart II. Stacked column chart III. Column chart IV. 100% stacked column chart v. 3-D chart

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

The Chart Styles gallery displays style options for the selected chart only.

If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.

Pie charts can only display one data series.

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

What chart type represents data as spokes going from the center to the outer edge of the chart?

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

What is a disadvantage of a stacked column chart?

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

To understand a chart, you need to include the chart data.

What does Excel not determine about the value axis when you create a chart?

It is good practice to delete any blank rows or columns before creating a chart.

________ charts are the most effective when they have seven or fewer categories.

In the task pane, what does a diagonal black triangle next to a chart category indicate?

In the task pane, what does a diagonal white triangle next to a chart category indicate?

Match the following terms with their description: i. Parallel range II. Alt Text III. Exploded pie chart IV. Arrange v. Chart filter