Excel Unit D Flashcards

Studying

1
Q

Is the horizontal axis.

A

X-Axis

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

Is the vertical axis.

A

Y-Axis

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

It is known as the horizontal axis because it often contains the names of data groups such as locations months or years.

A

Category Axis

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

It is known as the vertical axis because it often contains numerical value that help you interpret the size of chart elements.

A

Value Axis

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

3-D charts contains this for comparing data across both categories and values.

A

Z-Axis

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

The area inside the horizontal and vertical axes.

A

Plot Area

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

On the vertical axis.

A

Tick Marks

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

Extending across the plot area create a scale of measure for each value.

A

Gridlines

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

Each value in a cell you select for your chart.

A

Data Point

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

Visually represents each data point.

A

Data Marker

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

A collection of related data points.

A

Data Series

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

Each is made up of column data markers of a different color.

A

Legend

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

Because it is inserted directly in the current worksheet and doesn’t exist in a separate file.

A

Embedded Chart

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

The small series of dots at the corners and sides of the charts borders.

A

Sizing Handles

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

Is a sheet in a workbook that contains only a chart that is linked to the workbook data.

A

Chart Sheet

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

That serves as a visual indicator of data trends.

A

Sparkline

17
Q

Or an independent element on a worksheet and is not located in a specific cell or range.

A

Object

18
Q

Is two charts in one.

A

Combination Chart

19
Q

Such as a vertical axis on the right side of the chart.

A

Secondary Axis

20
Q

Represent the values at the value axis tick marks.

A

Major Gridlines

21
Q

Represent the values between the tick marks.

A

Minor Gridlines

22
Q

Are labels that further describe your data.

A

Text Annotations

23
Q

Are available in list, process, cycle, hierarchy, relationship, matrix, and pyramid categories.

A

SmartArt Graphics

24
Q

You can emphasize one data point.

A

Exploding