Question 1

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-#9

Accepted Answer

A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label 
A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label F

Question 2

To control the display of individual labels in a chart, use the ____________________ options in Chart Elements.

Accepted Answer

Data Labels
Data labels
data labels

Question 3

____ of the chart types have 3-D options, but these should be used with caution.

Accepted Answer

A)  Few 
B)  Most 
C)  Only one 
D)  All 
A)  Few 
B)  Most 
C)  Only one 
D)  All B

Question 4

The values in a bubble chart type are indicated by the distance from a center point.

Accepted Answer

A) True 
 B)False

Question 5

An X Y (Scatter) chart plots numeric values on both the x- and y-axes based on the value of the data.

Accepted Answer

A) True 
 B)False

Question 6

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

Accepted Answer

The answer of The groundbreaking book by Edward R. ____________________,...

Question 7

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point that assigns all the values below that point to the second plot.

Accepted Answer

A)  Position 
B)  Value 
C)  Percent Value 
D)  Custom 
A)  Position 
B)  Value 
C)  Percent Value 
D)  Custom

Question 8

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-#7

Accepted Answer

A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label 
A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Question 9

Charts can successfully organize a large collection of numbers, make comparisons between different parts of the data, and tell a story.

Accepted Answer

A) True 
 B)False

Question 10

To modify how gridlines display in a chart's plot area, use the ____________________ options in Chart Elements.

Accepted Answer

The answer of To modify how gridlines display in a...

Question 11

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

Accepted Answer

The answer of Microsoft Excel can be used to provide...

Question 12

____ graphically illustrate trends in the data using a statistical technique known as regression.

Accepted Answer

A)  Graph lines 
B)  Average lines 
C)  Trendlines 
D)  Datalines 
A)  Graph lines 
B)  Average lines 
C)  Trendlines 
D)  Datalines

Question 13

Identify the letter of the choice that best matches the phrase or definition.
-Bar chart type

Accepted Answer

A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category 
A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category

Question 14

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

Accepted Answer

A)  up bar 
B)  raise bar 
C)  increase bar 
D)  rich bar 
A)  up bar 
B)  raise bar 
C)  increase bar 
D)  rich bar

Question 15

The sum of the value of the categories must total ____ to use a pie chart.

Accepted Answer

A)  50% 
B)  75% 
C)  95% 
D)  100% 
A)  50% 
B)  75% 
C)  95% 
D)  100%

Question 16

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-#6

Accepted Answer

A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label 
A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Question 17

____ are the points in a data series at which the x-axis and y-axis values intersect.

Accepted Answer

A)  Data series 
B)  Data points 
C)  Legends 
D)  Chart titles 
A)  Data series 
B)  Data points 
C)  Legends 
D)  Chart titles

Question 18

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-#10

Accepted Answer

A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label 
A) Data series 
B) Chart title 
C) Data table 
D) X-axis labels 
E) X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Question 19

Identify the letter of the choice that best matches the phrase or definition.
-Column chart type

Accepted Answer

A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category 
A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category

Question 20

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

Accepted Answer

A)  on the worksheet with its data 
B)  on a worksheet separate from its data 
C)  in a new file 
D)  in separate workbooks 
A)  on the worksheet with its data 
B)  on a worksheet separate from its data 
C)  in a new file 
D)  in separate workbooks

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#9

To control the display of individual labels in a chart, use the ____________________ options in Chart Elements.

____ of the chart types have 3-D options, but these should be used with caution.

The values in a bubble chart type are indicated by the distance from a center point.

An X Y (Scatter) chart plots numeric values on both the x- and y-axes based on the value of the data.

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point that assigns all the values below that point to the second plot.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#7

Charts can successfully organize a large collection of numbers, make comparisons between different parts of the data, and tell a story.

To modify how gridlines display in a chart's plot area, use the ____________________ options in Chart Elements.

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

____ graphically illustrate trends in the data using a statistical technique known as regression.

Identify the letter of the choice that best matches the phrase or definition. -Bar chart type

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

The sum of the value of the categories must total ____ to use a pie chart.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#6

____ are the points in a data series at which the x-axis and y-axis values intersect.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#10

Identify the letter of the choice that best matches the phrase or definition. -Column chart type

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 3: Determining Effective Data Display with Charts

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#9

To control the display of individual labels in a chart, use the ____________________ options in Chart Elements.

____ of the chart types have 3-D options, but these should be used with caution.

The values in a bubble chart type are indicated by the distance from a center point.

An X Y (Scatter) chart plots numeric values on both the x- and y-axes based on the value of the data.

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point that assigns all the values below that point to the second plot.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#7

Charts can successfully organize a large collection of numbers, make comparisons between different parts of the data, and tell a story.

To modify how gridlines display in a chart's plot area, use the ____________________ options in Chart Elements.

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

____ graphically illustrate trends in the data using a statistical technique known as regression.

Identify the letter of the choice that best matches the phrase or definition. -Bar chart type

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

The sum of the value of the categories must total ____ to use a pie chart.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#6

____ are the points in a data series at which the x-axis and y-axis values intersect.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#10

Identify the letter of the choice that best matches the phrase or definition. -Column chart type

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters