Excel Chapter 3 Flashcards

1
Q

Chart that groups columns side by side to compare data points among categories

A

Clustered column chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Miniature chart contained in a single cell

A

Sparkling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Chart type that shows trends over time in which the value axis indicated quantities and horizontal axis indicated time

A

Line chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Label that describes the entire chart

A

Chart title

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Label that describes either the category axis or the value axis

A

Axis title

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Key that identifies the colour, gradient, picture, texture or pattern fill assigned to each data series in a chart

A

Legend

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Chart type that compared categories of data horizontally

A

Bar chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Chart that shows each data point in proportion to the whole data series

A

Pie chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Number of value that describes a single value on a chart

A

Data point

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Chart that contains two chart types to depict two types of data

A

Combo chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A circle that enables you to adjust the height or width of a chart

A

Sizing handle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Horizontal or vertical line that extend from axis through plot area

A

Gridline

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Chart type that shows the relationship between two variables

A

X Y (scatter) chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Group of related data points that display in rows or columns in a worksheet

A

Data series

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Window of options to format and customize chart elements

A

Task pane

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Provides descriptive labels for the data points plotted in a chart

A

Category axis

17
Q

Section or a chart that contains graphical representation of the values in a data series

A

Plot area

18
Q

A container for the entire chart and all of its elements

A

Chart area

19
Q

An identifier that shows the exact value of a data point in a chart

A

Data label

20
Q

Displays incremental numbers to identify approximate values, such as dollars or units, of data points in a chart

A

Value axis