Exam 20: Excel : Charts: Depicting Data Visually

A stacked column chart:

Applying a chart ________ allows you to change any number of formatting options such as the color of the chart area,the data,series,and the plot area.

A(n)________ chart displays values vertically where the height represents the value.

Which of the following is NOT one of most commonly used chart types?

A(n)________ is a key that identifies the color,gradient,picture,texture,or pattern assigned to each data series.

A pie chart:

A gridline is a line used to depict trends and forecast future data.

________ Styles add artistic style,text fill,and text effects to an object.

A chart can be resized from the Format tab.

Excel creates charts on the same worksheet as the original data set,but you can ________ the chart to its own chart sheet.

Excel automatically determines the starting,incremental,and stopping values on a chart based on the data selected.

A(n)________ is a worksheet that contains only a chart.

You can change the color scheme of a chart by clicking the Chart Styles button.

A(n)________ is a grid that contains the data source values and labels.

Which of the following charts displays lines connecting data points to show trends over equal time periods?

A category label:

Excel creates a chart on the same worksheet as the original data,but you can move the chart to its own chart sheet in the workbook.

In Excel 2013,Excel displays the ________ button in the bottom-right corner of a highlighted range.

Describe a column chart and the suggested limits of this type of chart.