Question 1

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

Accepted Answer

A) True 
 B)False

Question 2

The horizontal lines within a chart are called the horizontal ____________________.

Accepted Answer

The answer of The horizontal lines within a chart are...

Question 3

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

Accepted Answer

A) True 
 B)False

Question 4

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Accepted Answer

A) True 
 B)False

Question 5

Sparklines are displayed ____.

Accepted Answer

A)   above the chart
B)   below the chart
C)   next to the data they represent
D)   in the middle of the chartE) A) and D)
F) A) and B)

Question 6

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

Accepted Answer

The answer of A(n) ____________________ lets you quickly view the...

Question 7

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

Accepted Answer

A)   F3
B)   F5
C)   F7
D)   F11E) None of the above
F) A) and B)

Question 8

You can copy and paste formats from one label to another using the Format ____ feature.

Accepted Answer

A)   Duplicator
B)   Painter
C)   Replicator
D)   CopierE) A) and C)
F) A) and B)

Question 9

____ represent where the actual data would be in the chart.

Accepted Answer

A)   Data lines
B)   Data markers
C)   Chart metas
D)   Chart legendsE) A) and C)
F) None of the above

Question 10

A(n) data table displays the data used to create a chart.

Accepted Answer

A) True 
 B)False

Question 11

You can have the high, low, first, and last points on a sparkline display with ____________________.

Accepted Answer

The answer of You can have the high, low, first,...

Question 12

The data table used to create a chart appears above the chart.

Accepted Answer

A) True 
 B)False

Question 13

FIGURE EX 10-1  In Figure EX 10-1 above, item 1 points to the ____.

Accepted Answer

A)   legend
B)   data markers
C)   data table
D)   data seriesE) B) and D)
F) B) and C)

Question 14

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 15

You can create a sparkline for each row or column of data within a worksheet.

Accepted Answer

A) True 
 B)False

Question 16

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George is very proud of his performance because he has been able to make great progress in meeting the organization's fundraising goals. He can use a ____ chart to showcase the amount of progress accomplished so far.

Accepted Answer

A)   combination
B)   comparison
C)   gauge
D)   trackingE) C) and D)
F) A) and B)

Question 17

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

Accepted Answer

A)   sparklines
B)   data labels
C)   data series
D)   data tableE) A) and D)
F) B) and C)

Question 18

When making a chart with two y-axes, you will need to use a ____ data series.

Accepted Answer

A)   1-D
B)   2-D
C)   3-D
D)   4-DE) B) and D)
F) B) and C)

Question 19

Adding data labels allows you to see the value for each data marker in the chart.

Accepted Answer

A) True 
 B)False

Question 20

The y-axis on the left side of a combination chart is called the secondary axis.

Accepted Answer

A) True 
 B)False

Exam 16: Using Advanced Chart Features

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

Correct Answer
verified

Sparklines are displayed ____.

Correct Answer
verified

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

Correct Answer
verified

The data table used to create a chart appears above the chart.

Correct Answer
verified

The y-axis on the left side of a combination chart is called the secondary axis.

Correct Answer
verified

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

Correct Answer
verified

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Correct Answer
verified

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

Correct Answer
verified

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

Correct Answer
verified

FIGURE EX 10-1 In Figure EX 10-1 above, item 1 points to the ____.

Correct Answer
verified

You can have the high, low, first, and last points on a sparkline display with ____________________.

Correct Answer
verified

____ represent where the actual data would be in the chart.

Correct Answer
verified

When making a chart with two y-axes, you will need to use a ____ data series.

Correct Answer
verified

The horizontal lines within a chart are called the horizontal ____________________.

Correct Answer
verified

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

Correct Answer
verified

You can create a sparkline for each row or column of data within a worksheet.

Correct Answer
verified

Correct Answer
verified

Adding data labels allows you to see the value for each data marker in the chart.

Correct Answer
verified

A(n) data table displays the data used to create a chart.

Correct Answer
verified

You can copy and paste formats from one label to another using the Format ____ feature.

Correct Answer
verified

Exam 16: Using Advanced Chart Features

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

Correct AnswerverifiedShow Answer

Sparklines are displayed ____.

Correct AnswerverifiedShow Answer

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

Correct AnswerverifiedShow Answer

The data table used to create a chart appears above the chart.

Correct AnswerverifiedShow Answer

The y-axis on the left side of a combination chart is called the secondary axis.

Correct AnswerverifiedShow Answer

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

Correct AnswerverifiedShow Answer

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Correct AnswerverifiedShow Answer

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

Correct AnswerverifiedShow Answer

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

Correct AnswerverifiedShow Answer

FIGURE EX 10-1 In Figure EX 10-1 above, item 1 points to the ____.

Correct AnswerverifiedShow Answer

You can have the high, low, first, and last points on a sparkline display with ____________________.

Correct AnswerverifiedShow Answer

____ represent where the actual data would be in the chart.

Correct AnswerverifiedShow Answer

When making a chart with two y-axes, you will need to use a ____ data series.

Correct AnswerverifiedShow Answer

The horizontal lines within a chart are called the horizontal ____________________.

Correct AnswerverifiedShow Answer

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

Correct AnswerverifiedShow Answer

You can create a sparkline for each row or column of data within a worksheet.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Adding data labels allows you to see the value for each data marker in the chart.

Correct AnswerverifiedShow Answer

A(n) data table displays the data used to create a chart.

Correct AnswerverifiedShow Answer

You can copy and paste formats from one label to another using the Format ____ feature.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified