Exam 10: Effective Charts

The Quick Analysis tool quickly analyzes a selection in a worksheet and recommends chart types that best fit your data.

When first creating a chart,best practice dictates that you first consider and develop the basic ________ of the chart.

Which of the following is NOT a common issue that should be avoided when creating a chart?

An individual data value in a data series is a data ________.

Chart sizes can be locked so they do not resize when columns or rows are resized.

A group of related data values to be charted are called data points.

________ are small charts that are embedded into the cells in a worksheet.

The underlying data for a chart and labels is the ________ data.

If a chart is inserted on the same worksheet where the data lives,it is ________ on the worksheet.

There are ________ types of sparklines.

A(n)________ chart displays a horizontal representation of categorical data.

A column chart is a quantitative chart that shows growth or change in totals.

A ________ is a line that shows the direction of the data.

The ________ feature analyzes your data and suggests which chart would best represent your data.

It is fairly simple to create a perfect chart the first time you create it.

A pie chart shows trends over time.

A scatter chart shows the relationship between two numeric variables.

If a chart is selected,a(n)________ border surrounds the data that represents the legend labels.

The graphic components that are overlaid onto data in worksheet cells are called ________.