Question 1

In Excel,Axis Options allow you to specify ____.

Accepted Answer

A)  the axis type 
B)  where the vertical axis crosses 
C)  the axis position 
D)  all of the above 
A)  the axis type 
B)  where the vertical axis crosses 
C)  the axis position 
D)  all of the above

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Compares three sets of values in a three-dimensional 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 3

A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.

Accepted Answer

A)  multiple graphics 
B)  only one data set 
C)  only a single chart 
D)  embedded charts 
A)  multiple graphics 
B)  only one data set 
C)  only a single chart 
D)  embedded charts

Question 4

In Excel,typing ____ in the Format Code: box would result in that month's full name being displayed on a chart.

Accepted Answer

A)  m 
B)  mm 
C)  mmm 
D)  mmmm 
A)  m 
B)  mm 
C)  mmm 
D)  mmmm

Question 5

To explode a pie chart slice,select that slice and then drag it away from the pie._________________________

Accepted Answer

A) True 
 B)False

Question 6

In general,____________________ charts should be used only when the number of categories is small and the relative sizes of different data can be easily determined.

Accepted Answer

The answer of In general,____________________ charts should be used only...

Question 7

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Accepted Answer

A)  pie 
B)  column 
C)  line 
D)  area 
A)  pie 
B)  column 
C)  line 
D)  area

Question 8

Which of the following is not an option for setting units in the Axis Options portion of the Format Axis dialog box?

Accepted Answer

A)  Major unit 
B)  Minor unit 
C)  Sub unit 
D)  Base unit 
A)  Major unit 
B)  Minor unit 
C)  Sub unit 
D)  Base unit

Question 9

The ____ is a rectangular area that labels the markers or symbols used in a chart.

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  chart area 
D)  legend 
A)  x-axis 
B)  y-axis 
C)  chart area 
D)  legend

Question 10

The placement of tick marks and axis labels is controlled by the area indicated by Item ____ in the above figure.

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 11

Line charts are best suited for representing data that follows some sequential order.

Accepted Answer

A) True 
 B)False

Question 12

___________________ identify the main units on the chart axis.

Accepted Answer

The answer of ___________________ identify the main units on the...

Question 13

-In the figure above,the entry "yyyy" shown in the "Format Code:" box is setting up a(n)____ format to display the four-digit year.

Accepted Answer

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

Question 14

A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________

Accepted Answer

A) True 
 B)False

Question 15

To resize the chart,drag a sizing handle,which is a square or dot on the selection box that is used to change the object's width and height._________________________

Accepted Answer

A) True 
 B)False

Question 16

Charts include individual elements that can be formatted,including the chart area,the chart title,the plot area,data markers,and a legend.

Accepted Answer

A) True 
 B)False

Question 17

If you add percentages to a pie chart,the percentages would appear directly on the pie slices ____________________ enough to fit the number,otherwise,percentages will appear next to the slices in the chart area.

Accepted Answer

The answer of If you add percentages to a pie...

Question 18

The sparkline axis is simply a horizontal line that separates positive values from negative values._________________________

Accepted Answer

A) True 
 B)False

Question 19

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

Accepted Answer

A)  data 
B)  non-data 
C)  information 
D)  non-information 
A)  data 
B)  non-data 
C)  information 
D)  non-information

Question 20

To reposition the legend to the left-hand side of a chart,click the Legend button,and then click ____.

Accepted Answer

A)  Reposition Legend 
B)  Show Legend at Left 
C)  Move Legend 
D)  Adjust Legend 
A)  Reposition Legend 
B)  Show Legend at Left 
C)  Move Legend 
D)  Adjust Legend

In Excel,Axis Options allow you to specify ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.

In Excel,typing ____ in the Format Code: box would result in that month's full name being displayed on a chart.

To explode a pie chart slice,select that slice and then drag it away from the pie._________________________

In general,____________________ charts should be used only when the number of categories is small and the relative sizes of different data can be easily determined.

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Which of the following is not an option for setting units in the Axis Options portion of the Format Axis dialog box?

The ____ is a rectangular area that labels the markers or symbols used in a chart.

The placement of tick marks and axis labels is controlled by the area indicated by Item ____ in the above figure.

Line charts are best suited for representing data that follows some sequential order.

___________________ identify the main units on the chart axis.

-In the figure above,the entry "yyyy" shown in the "Format Code:" box is setting up a(n)____ format to display the four-digit year.

A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________

To resize the chart,drag a sizing handle,which is a square or dot on the selection box that is used to change the object's width and height._________________________

Charts include individual elements that can be formatted,including the chart area,the chart title,the plot area,data markers,and a legend.

If you add percentages to a pie chart,the percentages would appear directly on the pie slices ____________________ enough to fit the number,otherwise,percentages will appear next to the slices in the chart area.

The sparkline axis is simply a horizontal line that separates positive values from negative values._________________________

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

To reposition the legend to the left-hand side of a chart,click the Legend button,and then click ____.

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 Excel,Axis Options allow you to specify ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

A chart sheet can contain ____,enabling you to display several charts at once within a single sheet.

In Excel,typing ____ in the Format Code: box would result in that month's full name being displayed on a chart.

To explode a pie chart slice,select that slice and then drag it away from the pie._________________________

In general,____________________ charts should be used only when the number of categories is small and the relative sizes of different data can be easily determined.

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Which of the following is not an option for setting units in the Axis Options portion of the Format Axis dialog box?

The ____ is a rectangular area that labels the markers or symbols used in a chart.

The placement of tick marks and axis labels is controlled by the area indicated by Item ____ in the above figure.

Line charts are best suited for representing data that follows some sequential order.

___________________ identify the main units on the chart axis.

-In the figure above,the entry "yyyy" shown in the "Format Code:" box is setting up a(n)____ format to display the four-digit year.

A color bar is a conditional format that adds a horizontal bar to the background of a cell containing a numeric value._________________________

To resize the chart,drag a sizing handle,which is a square or dot on the selection box that is used to change the object's width and height._________________________

Charts include individual elements that can be formatted,including the chart area,the chart title,the plot area,data markers,and a legend.

If you add percentages to a pie chart,the percentages would appear directly on the pie slices ____________________ enough to fit the number,otherwise,percentages will appear next to the slices in the chart area.

The sparkline axis is simply a horizontal line that separates positive values from negative values._________________________

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

To reposition the legend to the left-hand side of a chart,click the Legend button,and then click ____.

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