Exam 8: Excell: Charts

Match the following terms with their description: i. Data labels II. Quick Layout III. Accessibility Compliance IV. Alt Text v. Sparklines

What is not a purpose of using an effective chart?

What icon is not displayed when you select a chart?

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

How many sizing handles are found on embedded charts?

A group of data points used in a graph become a data ________.

Match the following terms with their description: i. Sizing handles II. Chart font color III. Task pane IV. Diagonal black triangles v. Triangle with white fill

A data ________ is a group of related data points.

Match the following terms with their description: i. Data label II. Data point III. Data series IV. Data table v. Legend

Which of the following is not true about sizing handles?

You can enter data or formulas on a chart sheet.

You can switch the rows and columns in a chart to communicate a different perspective on your data.

Which of the following, when included, distorts the effectiveness of charting data points?

In a(n) ________ Excel uses a check mark to indicate which chart categories are displayed in a chart.

Which chart type cannot be displayed as a sparkline?

As a general rule, Pie charts should be limited to how many slices?

In rare cases you can chart text entries.

In a ________ column chart the data must be additive.

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

Do not include data ________ (such as totals or averages) and individual values in the same chart.