Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
Excel Chapter 3
Terms in this set (30)
Chart type to compare multiple categories of data vertically
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 chart
Label that describes either the category axis or the value axes
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 horizontally
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 shows the high, low, and close prices for individual stocks over time
Indicators that enable you to adjust the height and width of a selected chart
Horizontal or vertical line that extends from the horizontal or vertical axes 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 column(s) in a worksheet
Window of options to format and customize chart elements
Provides descriptive group names for subdividing a data series
Section of a chart that contains graphical representation of the values in a data series
Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels
Descriptive label that shows the exact value of the data points on the value axis
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?
What is the typical sequence for creating a chart?
Select the data source, select the chart type, and then size and position the chart
Which of the following applies to a sparkline?
If you want to show exact values for a data series in a bar chart, which chart element should you display?
The value axes currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?
Show Axis in Thousands
You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs?
100% stacked column chart
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?
Click Switch Row/Column in the Data group on the Design tab
Which tab contains commands to apply a predefined chart layout that controls which elements are included, where, and their color scheme?
Which icon does not display to the right of a selected chart?
Chart Quick Analysis
What indicates that the closing price was higher than the opening price in a stock chart?
A rectangle with a white fill color