Exam 20: Excel : Charts: Depicting Data Visually

The ________ group on the Design tab is useful for adjusting the data source of a chart.

Gridlines on a chart in Excel 2013 are:

A specific chart style controls the color of the chart area as well as the plot area.

A data point:

An X Y (scatter)chart shows:

To begin creating sparklines on a worksheet,click the ________ tab.

Excel 2013 automatically assigns a different pattern to each column of a clustered column chart.

How can you identify sizing handles when you click a chart?

Axes,chart titles,and data tables are examples of chart elements.

A chart ________ controls which data series and categories are visible in a chart.

Describe the three types of sparklines available in Excel 2013 and how each may be useful.

The ________ group on the Sparkline Tools Design tab allows you to change the selected sparkline type.

A disadvantage of a stacked column chart is that the segments within each column do not start at the same point.

Sparklines can be created by clicking the ________ tab.

Axes titles are:

Before you create a chart,you should delete any blank rows or columns in the primary data set from which you will create a chart.

What is a data series in Excel 2013?

A(n)________ chart displays a proportion of individual data points to the sum of all points.