Question 1

In the figure above,the value axis entries on the "Fund History" chart,are displayed with the ____ unit.

Accepted Answer

A)  tens 
B)  hundreds 
C)  thousands 
D)  millions 
A)  tens 
B)  hundreds 
C)  thousands 
D)  millions

Question 2

One of Edward Tufte's most important works is The Visual Display of Quantitative Information in which he laid out several principles for the design of charts and graphics.

Accepted Answer

A) True 
 B)False

Question 3

One advantage of breaking up a sparkline group is that Excel can display each sparkline based on the ____ values associated with the individual sparkline's data series.

Accepted Answer

A)  minimum 
B)  maximum 
C)  both a.and b. 
D)  neither a.nor b. 
A)  minimum 
B)  maximum 
C)  both a.and b. 
D)  neither a.nor b.

Question 4

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

Accepted Answer

The answer of Each data source is a collection of...

Question 5

Because of the visual distortion that can result with 3-D charts,you should ____.

Accepted Answer

A)  never use a 3-D chart 
B)  include data labels with all 3-D charts 
C)  use a 3-D chart only for charts with many data series 
D)  format all sections in similar colors 
A)  never use a 3-D chart 
B)  include data labels with all 3-D charts 
C)  use a 3-D chart only for charts with many data series 
D)  format all sections in similar colors

Question 6

To change a border color on a chart,click the Color button to open the color palette.

Accepted Answer

A) True 
 B)False

Question 7

-Referring to the figure above,the chart title for the pie chart is ____.

Accepted Answer

A)  Fund Assets 
B)  Sector Percentages 
C)  54.94% 
D)  Cash 
A)  Fund Assets 
B)  Sector Percentages 
C)  54.94% 
D)  Cash

Question 8

By default,embedded charts display the chart and any text or figures on separate pages.

Accepted Answer

A) True 
 B)False

Question 9

In a column chart,you can ____.

Accepted Answer

A)  add a gradient fill to columns 
B)  reduce gap width between columns 
C)  modify the appearance of data markers 
D)  all of the above 
A)  add a gradient fill to columns 
B)  reduce gap width between columns 
C)  modify the appearance of data markers 
D)  all of the above

Question 10

When selecting a data source for a pie chart,select all rows and columns,including total rows and columns.

Accepted Answer

A) True 
 B)False

In the figure above,the value axis entries on the "Fund History" chart,are displayed with the ____ unit.

One of Edward Tufte's most important works is The Visual Display of Quantitative Information in which he laid out several principles for the design of charts and graphics.

One advantage of breaking up a sparkline group is that Excel can display each sparkline based on the ____ values associated with the individual sparkline's data series.

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

Because of the visual distortion that can result with 3-D charts,you should ____.

To change a border color on a chart,click the Color button to open the color palette.

-Referring to the figure above,the chart title for the pie chart is ____.

By default,embedded charts display the chart and any text or figures on separate pages.

In a column chart,you can ____.

When selecting a data source for a pie chart,select all rows and columns,including total rows and columns.

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

In the figure above,the value axis entries on the "Fund History" chart,are displayed with the ____ unit.

One of Edward Tufte's most important works is The Visual Display of Quantitative Information in which he laid out several principles for the design of charts and graphics.

One advantage of breaking up a sparkline group is that Excel can display each sparkline based on the ____ values associated with the individual sparkline's data series.

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

Because of the visual distortion that can result with 3-D charts,you should ____.

To change a border color on a chart,click the Color button to open the color palette.

-Referring to the figure above,the chart title for the pie chart is ____.

By default,embedded charts display the chart and any text or figures on separate pages.

In a column chart,you can ____.

When selecting a data source for a pie chart,select all rows and columns,including total rows and columns.

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