Question 1

Clicking ____ a chart selects the chart.

Accepted Answer

A)  anywhere in 
B)  outside of 
C)  on the chart title only in 
D)  on the data series only in 
A)  anywhere in 
B)  outside of 
C)  on the chart title only in 
D)  on the data series only in A

Question 2

In a line chart, values are indicated by the filled areas below the lines.

Accepted Answer

A) True 
 B)False  False

Question 3

____ 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 B

Question 4

In the Open-High-Low-Close chart sub-type, ____ is used to show if the stock closed at a higher or lower price than its opening price.

Accepted Answer

A)  color 
B)  arrows 
C)  icons 
D)  none of the above 
A)  color 
B)  arrows 
C)  icons 
D)  none of the above

Question 5

In a scatter chart and a bubble chart, the x- and y-axes ____.

Accepted Answer

A)  are numeric 
B)  contain categories 
C)  either a or b 
D)  neither a nor b 
A)  are numeric 
B)  contain categories 
C)  either a or b 
D)  neither a nor b

Question 6

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 7

The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

Accepted Answer

A) True 
 B)False

Question 8

The purpose of formatting is to make a chart ____.

Accepted Answer

A)  easier for the viewer to understand 
B)  compact 
C)  colorful 
D)  contain as much data as possible 
A)  easier for the viewer to understand 
B)  compact 
C)  colorful 
D)  contain as much data as possible

Question 9

In a bubble chart, the larger the bubble, the _____ the value.

Accepted Answer

A)  larger 
B)  smaller 
C)  more complex 
D)  more simple 
A)  larger 
B)  smaller 
C)  more complex 
D)  more simple

Question 10

____________________ are small word-sized charts or graphics embedded within the words, numbers, and images they represent.

Accepted Answer

The answer of ____________________ are small word-sized charts or graphics...

Question 11

Although doughnut charts are not a chart sub-type, they are related to ____ because of the type of data displayed.

Accepted Answer

A)  100% stacked charts 
B)  pie charts 
C)  both a and b 
D)  neither a nor b 
A)  100% stacked charts 
B)  pie charts 
C)  both a and b 
D)  neither a nor b

Question 12

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 13

The ____________________ is the descriptive text that identifies a chart's contents.

Accepted Answer

The answer of The ____________________ is the descriptive text that...

Question 14

A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.

Accepted Answer

A)  area 
B)  stacked 
C)  contrast 
D)  radar 
A)  area 
B)  stacked 
C)  contrast 
D)  radar

Question 15

Excel datalines are small, word-sized graphics placed within the images or words they represent. _________________________

Accepted Answer

A) True 
 B)False

Question 16

Each segment in a radar chart is _____.

Accepted Answer

A)  always the same size as the other segments 
B)  always a different size than the other segments 
C)  always dependent on the other segments 
D)  always stated as a percentage 
A)  always the same size as the other segments 
B)  always a different size than the other segments 
C)  always dependent on the other segments 
D)  always stated as a percentage

Question 17

____ identify the categories plotted on the x-axis.

Accepted Answer

A)  Chart titles 
B)  Chart legends 
C)  Y-axis labels 
D)  X-axis labels 
A)  Chart titles 
B)  Chart legends 
C)  Y-axis labels 
D)  X-axis labels

Question 18

With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.

Accepted Answer

A)  High-Low-Close 
B)  Low-Close-High 
C)  Low-High-Close 
D)  High-Close-Low 
A)  High-Low-Close 
B)  Low-Close-High 
C)  Low-High-Close 
D)  High-Close-Low

Question 19

In a ____ chart, values are indicated by the height of the lines.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Clicking ____ a chart selects the chart.

In a line chart, values are indicated by the filled areas below the lines.

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

In the Open-High-Low-Close chart sub-type, ____ is used to show if the stock closed at a higher or lower price than its opening price.

In a scatter chart and a bubble chart, the x- and y-axes ____.

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

The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

The purpose of formatting is to make a chart ____.

In a bubble chart, the larger the bubble, the _____ the value.

____________________ are small word-sized charts or graphics embedded within the words, numbers, and images they represent.

Although doughnut charts are not a chart sub-type, they are related to ____ because of the type of data displayed.

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

The ____________________ is the descriptive text that identifies a chart's contents.

A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.

Excel datalines are small, word-sized graphics placed within the images or words they represent. _________________________

Each segment in a radar chart is _____.

____ identify the categories plotted on the x-axis.

With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.

In a ____ chart, values are indicated by the height of the lines.

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

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

Clicking ____ a chart selects the chart.

In a line chart, values are indicated by the filled areas below the lines.

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

In the Open-High-Low-Close chart sub-type, ____ is used to show if the stock closed at a higher or lower price than its opening price.

In a scatter chart and a bubble chart, the x- and y-axes ____.

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

The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

The purpose of formatting is to make a chart ____.

In a bubble chart, the larger the bubble, the _____ the value.

____________________ are small word-sized charts or graphics embedded within the words, numbers, and images they represent.

Although doughnut charts are not a chart sub-type, they are related to ____ because of the type of data displayed.

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

The ____________________ is the descriptive text that identifies a chart's contents.

A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.

Excel datalines are small, word-sized graphics placed within the images or words they represent. _________________________

Each segment in a radar chart is _____.

____ identify the categories plotted on the x-axis.

With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.

In a ____ chart, values are indicated by the height of the lines.

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

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