30 terms

Excel Chapter 3

STUDY
PLAY

Terms in this set (...)

Chart type to compare multiple categories of data vertically.
Clustered column chart
Miniature chart contained in a single cell.
Sparkline
Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time.
Line chart
Label that describes the chart.
Chart title
Label that describes either the category axis or the value axis.
Axis title
Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
Legend
Chart type that compares categories of data horizontally.
Bar chart
Chart that shows each data point in proportion to the whole data series.
Pie chart
Numeric value that decribes a single value on a chart.
Data point
Chart that shows the high, low, and close prices for individual stocks over time.
Stock chart
Indicators that enable you to adjust the height and width of a selected chart.
Sizing handle
Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
Gridline
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.
Data series
Window of options to format and customize chart elements.
Task pane
Provides descriptive group names for subdividing a data series.
Category axis
Section of a chart that contains graphical representation of the values in a data series.
Plot area
Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels.
Chart area
Descriptive label that shows the exact value of the data points on the value axis.
Data label
Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart.
Value axis
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 Layout 2 in the Chart Layouts group on the Design tab and apply a different chart style.

Click Legend in the Labels group on the Layout tab and select Show Legend at Bottom.

Click Switch Row/Column in the Data group on the Design tab.

Change the chart type to a clustered column chart.
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?

Design

Layout

Page Layout

Format
Design
Which icon does not display to the right of a selected chart?

Chart Quick Analysis

Chart Elements

Chart Styles

Chart Filters
Chart Quick Analysis
What indicates that the closing price was higher than the opening price in a stock chart?

A rectangle with a black fill color

A positive data label above the data series for a particular day

A double vertical line between the price markers

A rectangle with a white fill color
A rectangle with a white fill color
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?

Clustered bar chart

100% stacked column chart

Surface chart

Pie chart
100% stacked column chart
The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100?

Show Right to Left Axis

Show Axis in Millions

More Primary Vertical Axis Title Options

Show Axis in Thousands
Show Axis in Thousands
If you want to show exact values for a data series in a bar chart, which chart element should you display?

Data labels

Value axis title

Legend

Chart title
Data labels
Which of the following applies to a sparkline?

Chart title

Legend

Multiple data series

Single-cell chart
Single-cell chart
What is the typical sequence for creating a chart?

Click the cell to contain the chart, select the chart type, and then select the data source.

Select the chart type, select the data source, and then size and position the chart.

Select the data source, select the chart type, and then size and position the chart.

Select the data source, size the chart, select the chart type, and then position the chart.
Select the data source, select the chart type, and then size and position the chart.
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years?

Pie chart

Line chart

Column chart

Bar chart
Pie chart
YOU MIGHT ALSO LIKE...