Chapter 3 Flashcards

1
Q

A data point:

A

is a numeric value that describes a single value on a chart.

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

A stacked column chart:

A

places stacks of data in segments on top of each other in one column, with each
category in the data series represented by a different color.

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

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

A

Line chart

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

Where does a sparkline display?

A

In a single cell

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

a and b are called independent variables in the following mathematical equation:

y=ax + b
-true or false

A

false

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

What is a data series in Excel 2013?

A

A group of related data points

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

A bar chart:

A

compares values across categories using horizontal bars.

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

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

A

legend

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

A chart sheet:

A

chart placed in a separate worksheet

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

Chart1:

A

default chart sheet name

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

An embedded object:

A

chart on a worksheet

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

Chart style:

A

collection of formatting that controls the color of a data series, chart area, or plot area

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

Chart element:

A

component that completes or helps to clarify a chart

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

What describes a line chart?

A

A line chart uses a line to connect data points in order to show trends over a period of time.

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

What is a data series in Excel 2013?

A

a group of related data points

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