Exam 4: Effective Charts

To place an image into a chart,you click ________ in the Illustrations group on the INSERT tab.

In the chart above,the line to which the red arrow is pointing,is called a(n)________.

To enter a footer or header to a worksheet,you click Header & Footer in the:

If you wanted to see how the value of Apple's stock has changed during the past year,you would use a ________ chart.

To show changes over time,you would use a ________ chart.

A(n)________ chart is useful for showing categories that change over time and where each column represents a unit of time.

The chart shown above depicts a(n)________ chart.

By clicking the Chart Elements button,you can add,move,or remove data labels.

To create a pie chart,two data series,the labels and a set of corresponding values are required.

To show the relationship between two numeric variables,you would use a ________ chart.

Exploding a pie slice is a common pie chart enhancement.

To display the Format Data Labels task pane,you click the Data Labels ________ and select More Options.

A ________ chart is used to shows project schedule where each bar represents a project component or task.

To open the Format Axis task pane,you ________.

A chart is limited to a single data series.

When adding colors to a chart,more is better.

Which of the following is NOT a chart background fill option?

By default,Excel displays both major gridlines and minor gridlines on a chart.

A common enhancement for a scatter chart is the addition of ________.

To modify the layout and data in an existing chart,you click Change Chart Type in the ________.