Exam 8: Excell: Charts

In a column chart the horizontal axis displays the ________.

Match the following terms with their description: i. Line chart II. Pie chart III. Bar chart IV. Column chart v. Sparkline

Which axis displays incremental numbers to identify the approximate values of data points?

Where does the primary axis display on a Combo chart?

In a bar chart, which axis displays the categories?

A stacked column chart displays multiple columns for each category.

The ________ is the visual key to a chart.

Match the following terms with their description: i. Radar II. Histogram III. Area IV. X Y (scatter) chart v. Combo chart

What chart type can display two different chart types at the same time?

Excel normally uses all the selected data in creating a chart.

Effective charts never overwhelm an audience.

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

What can you not do from the Select Data Source dialog box?

Which of the following is not true about trendlines?

When you want to chart two related types of data, the Combo chart is perfect.

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

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

Match the following terms with their description: i. Chart element II. Chart filter III. Chart sheet IV. Chart style v. Chart title

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

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