m1 Flashcards

1
Q

a tool you can use in Excel to communicate data graphically

A

chart

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

a graphic or diagram that displays data or the relationships between sets of
data in picture form.

A

chart

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

TYPES OF CHARTS

A

column
line
pie
bar
area
surface

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

use vertical bars to represent data. They can work with many
different types of data, but they’re most frequently used for comparing information.

A

column charts

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

ideal for showing trends. The data points are connected with lines,
making it easy to see whether values are increasing or decreasing over time.

A

line charts

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

make it easy to compare proportions. Each value is shown as a slice
of the pie, so it’s easy to see which values make up the percentage of a whole.

A

pie charts

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

work just like column charts, but they use horizontal rather than vertical bars.

A

bar charts

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

are similar to line charts, except the areas under the lines are filled
in.

A

area charts

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

allow you to display data across a 3D landscape. They work
best with large data sets, allowing you to see a variety of information at the
same time.

A

surface charts

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

PARTS OF A CHART

A

title
vertical axis (y)
horizontal axis (x)
data series
legend

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

clearly describe what the chart is illustrating

A

title

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

also known as y axis

A

vertical axis

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

also known as x axis

A

horizontal axis

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

consists of related data points

A

data series

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

chart that can only have one data series

A

pie chart

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

indentifies which data series each color on the chart

A

legend

17
Q

OTHER CHARTS

A

scatterplot
bubble
doughnut
stock chart
radar chart
combo

18
Q

comparing/sharing numeric value, scientific, statistical, engineering

A

scatter plot

19
Q

show bubble in different size

A

bubble

20
Q

same as pie chart but contain more than one data series

A

doughnut

21
Q

show fluctuation in stock prices

A

stock chart

22
Q

compare aggregate values of several data series

A

radar chart

23
Q

2 or more chart type

A

combo