Exam 7: Excel : Charts

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

A(n)________ column chart displays the relationship of data points to the whole category.

The range used for a sparkline cannot include more than one row.

A chart sheet can hold, at most, two charts.

Which of the following is not a chart type?

Match the following terms with their description: I. Combo chart II. X Y (scatter)chart III. Stock chart IV. Area chart V. Surface chart A. One variable is plotted on the horizontal axis and the other on the vertical axis B. Colors are used between the lines C. Uses two dimensions and a continuous curve D. Combines two chart types E. Subtypes include: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close, and Volume-Open-High-Low-Close

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

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

Picking a chart ________ will allow you to change several formatting elements at the same time.

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

Match the following terms with their description: I. Data label II. Data point III. Data series IV. Data table V. Legend A. A group of data points B. Shows the precise value of a data point C. Helps to distinguish between various data series D. A precise value in a chart E. A grid used to plot data in a chart

What font color does Excel use by default for many of its elements?

What is a disadvantage of a stacked column chart?

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

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

Including the column and row labels in a chart makes the chart harder to understand.

Even after selecting a data source for a chart you can still apply various filters on one or more series.

If you wanted to show trends over set periods of time, you probably want to use a(n)________ chart.

In a stacked column chart the data must be ________.

Which of the following is not a chart element?