Deck 12: Microsoft Excel 2010,workshop 4: Using Charts

Question 1

The lines that go across charts to help gauge the size of the bars,columns,and data lines are known as ________.

A) data bars
B) sparklines
C) gridlines
D) trendlines

Answer 1

C

Question 2

Which of the following chart types compares groups of data in a horizontal fashion?

A) column
B) bar
C) pie
D) line

Answer 2

B

Question 3

Which of the following chart types does NOT display data in a standard X-Y plane?

A) bar
B) column
C) line
D) pie

Answer 3

D

Question 4

Which of the following chart types is most similar to a bar chart in terms of function?

A) column
B) pie
C) line
D) scatter

Question 5

Which of the following chart types would best help convey data that changes over a period of time?

A) pie
B) column
C) bar
D) line

Question 6

Which of the following charts could best depict the relationship between two variables?

A) column
B) pie
C) scatter
D) bar

Question 7

If a chart is placed inside of an existing worksheet,it is said to be a chart sheet.

Question 8

Which of the following chart types are most similar in function?

A) line and pie
B) bar and column
C) column and scatter
D) pie and bar

Question 9

Which of the following chart types would NOT be useful for displaying multiple categories of data on the same chart?

A) line
B) column
C) pie
D) bar

Question 10

Charts must be placed in an existing worksheet.

Question 11

Which of the following chart types would be used to compare parts of a whole?

A) bar
B) column
C) line
D) pie

Question 12

Which of the following statements regarding data series is FALSE?

A) A data series is made up of data points.
B) A chart can be made up of only one data series.
C) A data series is a range that will be charted.
D) A chart can be made up of multiple data series.

Question 13

A data point is made up of one or more data series.

Question 14

Which of the following chart types are most similar in function?

A) area and pie
B) area and line
C) column and scatter
D) scatter and pie

Question 15

Small charts embedded into a spreadsheet,usually next to the data,that facilitate quick analysis of trends are known as ________.

A) gridlines
B) trendlines
C) data bars
D) sparklines

Question 16

Which of the following charts could be used to easily group and compare categorized data sets?

A) pie
B) area
C) column
D) line

Question 17

If individual cells are filled in with colors,they have had ________ added to them.

A) trendlines
B) sparklines
C) data bars
D) gridlines

Question 18

Lines added to a chart that use current data to show the general direction of the data are referred to as ________.

A) trendlines
B) sparklines
C) data bars
D) gridlines

Question 19

Which of the following could be used to easily group and compare categorized data sets?

A) bar
B) line
C) area
D) scatter

Question 20

Which of the following chart types would display a series in a circular fashion?

A) bar
B) pie
C) column
D) line

Question 21

Both line charts and area charts are effective in displaying change over time.

Question 22

If a user wants to compare categorized data sets,it can be done effectively using a column chart.

Question 23

Bar charts and column charts are identical in function aside from the direction the bars are drawn in.

Question 24

Gridlines can be switched off,so that they do not display.

Question 25

A user wishes to chart people's height along the y-axis and their shoe size along the x-axis.A scatter chart is the best way to display this.

Question 26

Two chart types can be combined,for example,by overlaying a line chart on top of a column chart.

Question 27

If a user wants to compare categorized data sets,they can do so effectively using a bar chart.

Question 28

A scatter chart is best used to display change over time.

Question 29

An individual piece of data on a data series is also known as a(n)________.

Question 30

Sparklines facilitate quick analysis of trends.

Question 31

A common method to emphasize information on scatter charts is to add a trendline.

Question 32

A set of data to be charted is also known as a(n)________.

Question 33

Each slice of a piece chart is an example of a data ________.

Question 34

There is only one type of trendline that can be added to a chart.

Question 35

All types of charts can be exploded.

Question 36

The scale of an axis refers to the color of that axis's lines.

Question 37

A common method of emphasizing data in a pie chart is by adding a trendline.

Question 38

A(n)________ chart would best be used if you wanted to display parts of a whole,such as comparing sales for four salespeople to see who has sold the largest percentage of goods.

Question 39

Pie charts can display parts of a whole effectively.

Question 40

Scatter charts convey the relationship between two variables.

Question 41

A pie chart is said to be ________ if it has one slice pulled away from the main pie.

Question 42

A(n)________ chart conveys the relationship between two variables.

Question 43

To compare data in groups horizontally,use a(n)________ chart.

Question 44

Changing all numbers under 50 to red,numbers between 51 and 80 to yellow,and numbers above 80 to green can be done using a specialized data bar type called ________.

Question 45

Graphical components overlaid onto data in worksheet cells are known as ________.

Question 46

A simple way to display change over time,which also emphasizes the data by displaying colored layers,is by using a(n)________ chart.

Question 47

A line that uses current data to show a pattern of information for data is also known as a(n)________.

Question 48

To compare data in groups vertically,use a(n)________ chart.

Question 49

A(n)________ chart is used within a spreadsheet to give an immediate visual trend analysis and it adjusts as the source data changes.

Question 50

Small charts embedded into a spreadsheet next to the data to facilitate quick analysis of trends are known as ________.

Question 51

A simple way to display change over time,without displaying colored layers,is by using a(n)________ chart.

Question 52

A(n)________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

Question 53

A bar chart is most similar in function to a(n)________ chart.

Question 54

The lines that go across charts to help gauge the size of the bars,columns,or data lines are known as ________.