Question 1

A column sparkline can be ____.

Accepted Answer

A)  inserted anywhere within the workbook 
B)  can represent data from several rows 
C)  can represent data from several columns 
D)  any of the above 
A)  inserted anywhere within the workbook 
B)  can represent data from several rows 
C)  can represent data from several columns 
D)  any of the above

Question 2

Andy has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

Accepted Answer

A)  Delete parts of the data 
B)  Delete the legend 
C)  Delete the title 
D)  Overlay the legend in areas without data 
A)  Delete parts of the data 
B)  Delete the legend 
C)  Delete the title 
D)  Overlay the legend in areas without data

Question 3

Every chart must have a data source.

Accepted Answer

A) True 
 B)False

Question 4

In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.

Accepted Answer

The answer of In cases where a label placed outside...

Question 5

Excel has a built-in format to display four-digit year values,so you do not need to create one.

Accepted Answer

A) True 
 B)False

Question 6

Pie charts are most effective with ten or fewer slices._________________________

Accepted Answer

A) True 
 B)False

Question 7

If you have chosen Outside End,Percentage,and Show Leader Lines,you are setting options in the ____ box.

Accepted Answer

A)  Label Options 
B)  Format Legend 
C)  Format Chart Area 
D)  Format Axis 
A)  Label Options 
B)  Format Legend 
C)  Format Chart Area 
D)  Format Axis

Question 8

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________

Accepted Answer

A) True 
 B)False

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Often used to show trends and changes over time

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 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the height of each ____.

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 11

In Excel charts,the Legend Options dialog box allows you to change all the following except ____.

Accepted Answer

A)  Fill 
B)  Border Color 
C)  Shadow 
D)  Font Size 
A)  Fill 
B)  Border Color 
C)  Shadow 
D)  Font Size

Question 12

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

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 14

Since Anya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

Accepted Answer

A)  paste her chart in as a picture 
B)  do nothing since charts in Excel remain linked to data sources 
C)  manually adjust data in a chart 
D)  create a new chart each time she modifies her data 
A)  paste her chart in as a picture 
B)  do nothing since charts in Excel remain linked to data sources 
C)  manually adjust data in a chart 
D)  create a new chart each time she modifies her data

Question 15

____provide descriptive text for the individual data markers,such as pie slices

Accepted Answer

A)  Asset labels 
B)  Legend values 
C)  Data labels 
D)  Leader lines 
A)  Asset labels 
B)  Legend values 
C)  Data labels 
D)  Leader lines

Question 16

A ____ acts like a line on a ruler,making it easier to read a chart's scale.

Accepted Answer

A)  major tick mark 
B)  data marker 
C)  category value 
D)  legend marker 
A)  major tick mark 
B)  data marker 
C)  category value 
D)  legend marker

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the length of the ____

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 18

Excel supports ____________________ built-in charts.

Accepted Answer

73
seventy

Question 19

A(n)____ chart is similar to a line chart,but uses a fill color to shade areas under the lines.

Accepted Answer

A)  bar 
B)  area 
C)  stock 
D)  column 
A)  bar 
B)  area 
C)  stock 
D)  column

Question 20

-In the figure above,the date formats shown in the

Accepted Answer

A)  built-in formats 
B)  custom formats 
C)  default formats 
D)  archived formats 
A)  built-in formats 
B)  custom formats 
C)  default formats 
D)  archived formats

A column sparkline can be ____.

Andy has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

Every chart must have a data source.

In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.

Excel has a built-in format to display four-digit year values,so you do not need to create one.

Pie charts are most effective with ten or fewer slices._________________________

If you have chosen Outside End,Percentage,and Show Leader Lines,you are setting options in the ____ box.

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Often used to show trends and changes over time

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the height of each ____.

In Excel charts,the Legend Options dialog box allows you to change all the following except ____.

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Since Anya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

____provide descriptive text for the individual data markers,such as pie slices

A ____ acts like a line on a ruler,making it easier to read a chart's scale.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the length of the ____

Excel supports ____________________ built-in charts.

A(n)____ chart is similar to a line chart,but uses a fill color to shade areas under the lines.

-In the figure above,the date formats shown in the

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

A column sparkline can be ____.

Andy has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

Every chart must have a data source.

In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.

Excel has a built-in format to display four-digit year values,so you do not need to create one.

Pie charts are most effective with ten or fewer slices._________________________

If you have chosen Outside End,Percentage,and Show Leader Lines,you are setting options in the ____ box.

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Often used to show trends and changes over time

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the height of each ____.

In Excel charts,the Legend Options dialog box allows you to change all the following except ____.

When you create sparklines,clicking any cell in the data range selects all of the sparklines in the group._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Since Anya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

____provide descriptive text for the individual data markers,such as pie slices

A ____ acts like a line on a ruler,making it easier to read a chart's scale.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the length of the ____

Excel supports ____________________ built-in charts.

A(n)____ chart is similar to a line chart,but uses a fill color to shade areas under the lines.

-In the figure above,the date formats shown in the

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