Question 1

To add an axis to a sparkline,click the Axis button in the ____ group on the Sparkline Tools Design tab,and then click Show Axis.

Accepted Answer

A)  Group 
B)  Tools 
C)  Design 
D)  Chart 
A)  Group 
B)  Tools 
C)  Design 
D)  Chart

Question 2

You can rotate a 3-D chart along the x-axis,y-axis,and z-axis.

Accepted Answer

A) True 
 B)False

Question 3

-Referring to the figure above,the rectangular area to the right of the pie chart (listing Cash,U.S.Stocks,Non-U.S.Stocks,and Bonds)is the ____.

Accepted Answer

A)  perspective 
B)  plot area 
C)  legend 
D)  data marker 
A)  perspective 
B)  plot area 
C)  legend 
D)  data marker

Question 4

-In the above figure,the data markers shown in the cells in the column labeled "Performance," are ____.

Accepted Answer

A)  data lines 
B)  sparklines 
C)  data bars 
D)  spark bars 
A)  data lines 
B)  sparklines 
C)  data bars 
D)  spark bars

Question 5

In Excel,charts do not remain linked or connected to their data sources if they appear in different worksheets.

Accepted Answer

A) True 
 B)False

Question 6

After you select the data source,Excel determines the series name,series values,and category values based on the data source._________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following represents a range of data in Excel?

Accepted Answer

A)  A2-B2 
B)  B7,C4 
C)  A1.M4 
D)  C2:F12 
A)  A2-B2 
B)  B7,C4 
C)  A1.M4 
D)  C2:F12

Question 8

If you cannot find the right chart to meet your needs,Excel allows you to create a custom chart based on the built-in chart types.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following represents the pointer when it is over a blank spot in the chart legend?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 10

Placing a chart in a ____ displays only the chart and no worksheet cells.

Accepted Answer

A)  new worksheet 
B)  tabbed view 
C)  graph display 
D)  chart sheet 
A)  new worksheet 
B)  tabbed view 
C)  graph display 
D)  chart sheet

Question 11

Chart sheets show both charts and worksheet data.

Accepted Answer

A) True 
 B)False

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Another term for Scatter chart

Accepted Answer

A) Bubble 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Doughnut
H)Bar
I)Surface
J)Area
K)Stock
L)Scatter 
A) Bubble 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Doughnut
H)Bar
I)Surface
J)Area
K)Stock
L)Scatter

Question 13

Anya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

Accepted Answer

A)  line chart 
B)  exploded pie chart 
C)  scatter chart 
D)  banded chart 
A)  line chart 
B)  exploded pie chart 
C)  scatter chart 
D)  banded chart

Question 14

-The columns and pie slices in the charts above are ____.

Accepted Answer

A)  data markers 
B)  chart areas 
C)  major tick marks 
D)  minor tick marks 
A)  data markers 
B)  chart areas 
C)  major tick marks 
D)  minor tick marks

Question 15

To create a combination chart,you select a data series in an existing chart,and then apply a new ___________________ to that series.

Accepted Answer

The answer of To create a combination chart,you select a...

Question 16

Explain when it would be appropriate to use a chart sheet and how you would go about creating one in Microsoft Excel.

Accepted Answer

A chart sheet can contain embedded chart

Question 17

Anya tells you that she is using a 3-D chart for the first time and asks if you have any advice for this chart type.You should tell Anya that it's especially important to ____ in 3-D charts.

Accepted Answer

A)  include data labels 
B)  use bright colors 
C)  use a small font 
D)  detail the legend and title 
A)  include data labels 
B)  use bright colors 
C)  use a small font 
D)  detail the legend and title

Question 18

The lengths of data bars are based on the value of each cell in the selected range.

Accepted Answer

A) True 
 B)False

Question 19

Embedded charts can be moved and resized.

Accepted Answer

A) True 
 B)False

Question 20

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

Accepted Answer

Answers will vary.Students should cover

To add an axis to a sparkline,click the Axis button in the ____ group on the Sparkline Tools Design tab,and then click Show Axis.

You can rotate a 3-D chart along the x-axis,y-axis,and z-axis.

-Referring to the figure above,the rectangular area to the right of the pie chart (listing Cash,U.S.Stocks,Non-U.S.Stocks,and Bonds)is the ____.

-In the above figure,the data markers shown in the cells in the column labeled "Performance," are ____.

In Excel,charts do not remain linked or connected to their data sources if they appear in different worksheets.

After you select the data source,Excel determines the series name,series values,and category values based on the data source._________________________

Which of the following represents a range of data in Excel?

If you cannot find the right chart to meet your needs,Excel allows you to create a custom chart based on the built-in chart types.

Which of the following represents the pointer when it is over a blank spot in the chart legend?

Placing a chart in a ____ displays only the chart and no worksheet cells.

Chart sheets show both charts and worksheet data.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for Scatter chart

Anya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

-The columns and pie slices in the charts above are ____.

To create a combination chart,you select a data series in an existing chart,and then apply a new ___________________ to that series.

Explain when it would be appropriate to use a chart sheet and how you would go about creating one in Microsoft Excel.

Anya tells you that she is using a 3-D chart for the first time and asks if you have any advice for this chart type.You should tell Anya that it's especially important to ____ in 3-D charts.

The lengths of data bars are based on the value of each cell in the selected range.

Embedded charts can be moved and resized.

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 4: Enhancing a Workbook With Charts and Graphs

To add an axis to a sparkline,click the Axis button in the ____ group on the Sparkline Tools Design tab,and then click Show Axis.

You can rotate a 3-D chart along the x-axis,y-axis,and z-axis.

-Referring to the figure above,the rectangular area to the right of the pie chart (listing Cash,U.S.Stocks,Non-U.S.Stocks,and Bonds)is the ____.

-In the above figure,the data markers shown in the cells in the column labeled "Performance," are ____.

In Excel,charts do not remain linked or connected to their data sources if they appear in different worksheets.

After you select the data source,Excel determines the series name,series values,and category values based on the data source._________________________

Which of the following represents a range of data in Excel?

If you cannot find the right chart to meet your needs,Excel allows you to create a custom chart based on the built-in chart types.

Which of the following represents the pointer when it is over a blank spot in the chart legend?

Placing a chart in a ____ displays only the chart and no worksheet cells.

Chart sheets show both charts and worksheet data.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Another term for Scatter chart

Anya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

-The columns and pie slices in the charts above are ____.

To create a combination chart,you select a data series in an existing chart,and then apply a new ___________________ to that series.

Explain when it would be appropriate to use a chart sheet and how you would go about creating one in Microsoft Excel.

Anya tells you that she is using a 3-D chart for the first time and asks if you have any advice for this chart type.You should tell Anya that it's especially important to ____ in 3-D charts.

The lengths of data bars are based on the value of each cell in the selected range.

Embedded charts can be moved and resized.

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters