Question 1

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

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 2

The chart title is the descriptive text that identifies the chart's contents.
_________________________

Accepted Answer

A) True 
 B)False

Question 3

To display a moving average along with your chart data, use the ____________________ option in Chart Elements.

Accepted Answer

The answer of To display a moving average along with...

Question 4

The ____________________ chart type displays value trends in three dimensions. Values are indicated by areas with colors or patterns on the surface of the chart.

Accepted Answer

The answer of The ____________________ chart type displays value trends...

Question 5

The radar chart is similar in structure to a spider web, with each "web strand" that roughly
Forms a circle representing the ____.

Accepted Answer

A)  data values 
B)  x-axis 
C)  y-axis 
D)  data labels 
A)  data values 
B)  x-axis 
C)  y-axis 
D)  data labels

Question 6

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

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

You must make changes to the content of data labels using buttons in the Format Data Labels task pane.

Accepted Answer

A) True 
 B)False

Question 8

The Description options on the Chart Elements menu control the display and placement of the chart legend.

Accepted Answer

A) True 
 B)False

Question 9

The Chart Elements menu allows you to control the appearance of the ____.

Accepted Answer

A)  legend 
B)  data labels 
C)  chart title and axis titles 
D)  all of the above 
A)  legend 
B)  data labels 
C)  chart title and axis titles 
D)  all of the above

Question 10

The ____ is the horizontal axis where categories are plotted.

Accepted Answer

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

Question 11

A ____ chart displays trends in three dimensions, with values in colored or patterned areas on the surface of the chart.

Accepted Answer

A)  column 
B)  radar 
C)  bubble 
D)  surface 
A)  column 
B)  radar 
C)  bubble 
D)  surface

Question 12

A line chart plots numeric values on one axis and category labels equidistantly on the other axis.

Accepted Answer

A) True 
 B)False

Question 13

The ____ chart type displays stock price and volume trends over time.

Accepted Answer

A)  finance 
B)  stock 
C)  Wall Street 
D)  trader 
A)  finance 
B)  stock 
C)  Wall Street 
D)  trader

Question 14

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 15

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point by percentage, rather than value, and assign all the percentages below that point to the second plot.

Accepted Answer

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

Question 16

The Data Labels category found on the Chart Elements menu provides options for changing the information the label displays as well as the label position. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Name and briefly describe five of the eleven chart types listed in the chapter.

Accepted Answer

•Column: Compares values across categori

Question 18

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

Question 19

Charts can be placed on a separate worksheet that is referred to as a ____.

Accepted Answer

A)  chart sheet 
B)  cheat sheet 
C)  worksheet 
D)  chart page 
A)  chart sheet 
B)  cheat sheet 
C)  worksheet 
D)  chart page

Question 20

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

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

The chart title is the descriptive text that identifies the chart's contents. _________________________

To display a moving average along with your chart data, use the ____________________ option in Chart Elements.

The ____________________ chart type displays value trends in three dimensions. Values are indicated by areas with colors or patterns on the surface of the chart.

The radar chart is similar in structure to a spider web, with each "web strand" that roughly Forms a circle representing the ____.

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

You must make changes to the content of data labels using buttons in the Format Data Labels task pane.

The Description options on the Chart Elements menu control the display and placement of the chart legend.

The Chart Elements menu allows you to control the appearance of the ____.

The ____ is the horizontal axis where categories are plotted.

A ____ chart displays trends in three dimensions, with values in colored or patterned areas on the surface of the chart.

A line chart plots numeric values on one axis and category labels equidistantly on the other axis.

The ____ chart type displays stock price and volume trends over time.

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

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point by percentage, rather than value, and assign all the percentages below that point to the second plot.

The Data Labels category found on the Chart Elements menu provides options for changing the information the label displays as well as the label position. _________________________

Name and briefly describe five of the eleven chart types listed in the chapter.

Clicking ____ a chart selects the chart.

Charts can be placed on a separate worksheet that is referred to as a ____.

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.

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. -#3

The chart title is the descriptive text that identifies the chart's contents. _________________________

To display a moving average along with your chart data, use the ____________________ option in Chart Elements.

The ____________________ chart type displays value trends in three dimensions. Values are indicated by areas with colors or patterns on the surface of the chart.

The radar chart is similar in structure to a spider web, with each "web strand" that roughly Forms a circle representing the ____.

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

You must make changes to the content of data labels using buttons in the Format Data Labels task pane.

The Description options on the Chart Elements menu control the display and placement of the chart legend.

The Chart Elements menu allows you to control the appearance of the ____.

The ____ is the horizontal axis where categories are plotted.

A ____ chart displays trends in three dimensions, with values in colored or patterned areas on the surface of the chart.

A line chart plots numeric values on one axis and category labels equidistantly on the other axis.

The ____ chart type displays stock price and volume trends over time.

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

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point by percentage, rather than value, and assign all the percentages below that point to the second plot.

The Data Labels category found on the Chart Elements menu provides options for changing the information the label displays as well as the label position. _________________________

Name and briefly describe five of the eleven chart types listed in the chapter.

Clicking ____ a chart selects the chart.

Charts can be placed on a separate worksheet that is referred to as a ____.

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.

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