Question 1

Pie charts can display parts of a whole effectively.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of The lines that go across charts to...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

Charts must be placed in an existing worksheet.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The answer of A simple way to display change over...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of Each slice of a piece chart is...

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

The answer of A set of data to be charted...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The answer of A(n)________ chart is used within a spreadsheet...

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

Pie charts can display parts of a whole effectively.

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

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

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

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

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

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

Charts must be placed in an existing worksheet.

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

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.

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

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

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

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

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

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

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

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

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

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