Question 1

Which of the following is not an option in the Fill options in the Format Data Series dialog box?

Accepted Answer

A)  Preset colors 
B)  Direction 
C)  Angle 
D)  all of the above are options 
A)  Preset colors 
B)  Direction 
C)  Angle 
D)  all of the above are options

Question 2

Anya has asked for your advice.A colleague told her to remove the legend from her pie chart,but she doesn't understand why.What would be a good reason to remove the title?

Accepted Answer

A)  Her legend isn't labeled properly. 
B)  Her legend takes up too much space. 
C)  When using one data series,it can be redundant to use a chart title and legend. 
D)  There is no good reason.You should always have a title and legend. 
A)  Her legend isn't labeled properly. 
B)  Her legend takes up too much space. 
C)  When using one data series,it can be redundant to use a chart title and legend. 
D)  There is no good reason.You should always have a title and legend.

Question 3

In the Format Axis dialog box,selecting Fixed 0.10 for the Minor Unit will result in ____.

Accepted Answer

A)  minor tick marks appearing at 10% intervals 
B)  major tick marks appearing at 10% intervals 
C)  minor tick marks automatically appearing per the data 
D)  values appearing in reverse order 
A)  minor tick marks appearing at 10% intervals 
B)  major tick marks appearing at 10% intervals 
C)  minor tick marks automatically appearing per the data 
D)  values appearing in reverse order

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Similar to the pie chart except that it can display multiple sets of data

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 5

Because of the compactness of sparklines,you can specify only the line color and the line leader color._________________________

Accepted Answer

A) True 
 B)False

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Compares values from different categories.Areas under the lines contain a fill color

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 7

If you select a chart's series and look at the formula bar,the formula being displayed uses the ____ function.

Accepted Answer

A)  CHART 
B)  DATA 
C)  RANGE 
D)  SERIES 
A)  CHART 
B)  DATA 
C)  RANGE 
D)  SERIES

Question 8

The ____ is not a component of a data series.

Accepted Answer

A)  series name 
B)  series value 
C)  category name 
D)  category value 
A)  series name 
B)  series value 
C)  category name 
D)  category value

Question 9

If you want to represent the following data: 20%,25%,15%,17%,and 23%,a pie chart will best highlight the differences among the close in value data._________________________

Accepted Answer

A) True 
 B)False

Question 10

If you do not want a chart to reflect new values in the data source,you should ____.

Accepted Answer

A)  not create a chart 
B)  change the default settings 
C)  paste the chart as a Picture 
D)  create the chart in Microsoft Word 
A)  not create a chart 
B)  change the default settings 
C)  paste the chart as a Picture 
D)  create the chart in Microsoft Word

Question 11

A 90° ____ value exaggerates the 3-D effect,making distant objects appear very small.

Accepted Answer

A)  angle 
B)  perspective 
C)  photo 
D)  rotation 
A)  angle 
B)  perspective 
C)  photo 
D)  rotation

Question 12

The ____,shown in the figure above,include data markers to indicate the high and low points.

Accepted Answer

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

Question 13

From the Format Data Series dialog box,you can ____ as a Marker Option.

Accepted Answer

A)  select a built-in marker type 
B)  choose a data marker type 
C)  select the size of the data marker 
D)  all of the above 
A)  select a built-in marker type 
B)  choose a data marker type 
C)  select the size of the data marker 
D)  all of the above

Question 14

When selecting a chart,it's important to choose the right type of chart to represent your data.If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

Accepted Answer

Answers will vary.Students should eviden

Question 15

-Referring to the figure above,if you were to create a Fund Assets pie chart using the information in A1:B7,the data source for that chart would be ____.

Accepted Answer

A)  A2:A6 
B)  B2:B6 
C)  A1:B5 
D)  A2:B6 
A)  A2:A6 
B)  B2:B6 
C)  A1:B5 
D)  A2:B6

Question 16

Extreme viewing angles in a 3-D chart may elongate the chart and misrepresent the data._________________________

Accepted Answer

A) True 
 B)False

Question 17

____ is not an available formatting category for legends.

Accepted Answer

A)  Border Color 
B)  Border Styles 
C)  Shadow 
D)  Shading 
A)  Border Color 
B)  Border Styles 
C)  Shadow 
D)  Shading

Question 18

-Referring to the figure above,the entry 54.94%,shown next to the largest pie slice,is a ____.

Accepted Answer

A)  data label 
B)  chart key 
C)  legend 
D)  series value 
A)  data label 
B)  chart key 
C)  legend 
D)  series value

Question 19

On a 3-D chart,the ____ represents the object's depth.

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  z-axis 
D)  none of the above 
A)  x-axis 
B)  y-axis 
C)  z-axis 
D)  none of the above

Question 20

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

Accepted Answer

The answer of A(n)____________________ chart shows patterns or relationships between...

Which of the following is not an option in the Fill options in the Format Data Series dialog box?

Anya has asked for your advice.A colleague told her to remove the legend from her pie chart,but she doesn't understand why.What would be a good reason to remove the title?

In the Format Axis dialog box,selecting Fixed 0.10 for the Minor Unit will result in ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Similar to the pie chart except that it can display multiple sets of data

Because of the compactness of sparklines,you can specify only the line color and the line leader color._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.Areas under the lines contain a fill color

If you select a chart's series and look at the formula bar,the formula being displayed uses the ____ function.

The ____ is not a component of a data series.

If you want to represent the following data: 20%,25%,15%,17%,and 23%,a pie chart will best highlight the differences among the close in value data._________________________

If you do not want a chart to reflect new values in the data source,you should ____.

A 90° ____ value exaggerates the 3-D effect,making distant objects appear very small.

The ____,shown in the figure above,include data markers to indicate the high and low points.

From the Format Data Series dialog box,you can ____ as a Marker Option.

When selecting a chart,it's important to choose the right type of chart to represent your data.If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

-Referring to the figure above,if you were to create a Fund Assets pie chart using the information in A1:B7,the data source for that chart would be ____.

Extreme viewing angles in a 3-D chart may elongate the chart and misrepresent the data._________________________

____ is not an available formatting category for legends.

-Referring to the figure above,the entry 54.94%,shown next to the largest pie slice,is a ____.

On a 3-D chart,the ____ represents the object's depth.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

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

Which of the following is not an option in the Fill options in the Format Data Series dialog box?

Anya has asked for your advice.A colleague told her to remove the legend from her pie chart,but she doesn't understand why.What would be a good reason to remove the title?

In the Format Axis dialog box,selecting Fixed 0.10 for the Minor Unit will result in ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Similar to the pie chart except that it can display multiple sets of data

Because of the compactness of sparklines,you can specify only the line color and the line leader color._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.Areas under the lines contain a fill color

If you select a chart's series and look at the formula bar,the formula being displayed uses the ____ function.

The ____ is not a component of a data series.

If you want to represent the following data: 20%,25%,15%,17%,and 23%,a pie chart will best highlight the differences among the close in value data._________________________

If you do not want a chart to reflect new values in the data source,you should ____.

A 90° ____ value exaggerates the 3-D effect,making distant objects appear very small.

The ____,shown in the figure above,include data markers to indicate the high and low points.

From the Format Data Series dialog box,you can ____ as a Marker Option.

When selecting a chart,it's important to choose the right type of chart to represent your data.If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

-Referring to the figure above,if you were to create a Fund Assets pie chart using the information in A1:B7,the data source for that chart would be ____.

Extreme viewing angles in a 3-D chart may elongate the chart and misrepresent the data._________________________

____ is not an available formatting category for legends.

-Referring to the figure above,the entry 54.94%,shown next to the largest pie slice,is a ____.

On a 3-D chart,the ____ represents the object's depth.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

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