Excel Chapter 3
Terms in this set (27)
Chart that groups columns side by side to compare data points among catergories
Clustered Column chart
Miniature chart contained in a single cell
Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time
Label that describes the entire chart
Label that describes either the category axis or the value axis
Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart
Chart type that compares categories of data
Chart that shows each data point in proportion to the whole data series
Numeric value that describes a single value on a chart
Chart that contains two chart types, such as column and line, to depict two types of data, such as individual data points and percentages
A circle that enables you to adjust the height or width of a selected chart
Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area
Chart type that shows the relationship between two variables
X Y (scatter) Chart
Group of related data points that display in row(s) or columns(s) in a worksheet
Window of options to format and customize chart elements
Provides descriptive labels for the data points plotted in a chart
Section of a chart that contains graphical representation of the values in a data series
A container for entire chart and all of its elements
An identifier that shows the exact value of a data point in a chart
Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?
(a. Pie chart)
(b. Line chart)
(c. Column chart)
(d. Bar chart)
(a. pie chart)
Which of the following is not a type of sparkline?
If you want to show exact values for a data series in a bar chart, which element should you display?
You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart will accommodate your needs?
100% stacked column chart
What do you click to remove a data series from a chart so that you can focus on other data series?
Which of the following does not display automatically when you create a clustered column chart?
(a. Data labels)
(b. Chart title placeholder)
(c. Grid lines)
a. Data labels
After you create a line type sparkline , what option should you select to display dots for each data points?