Question 1

____ charts all have a stacked chart sub-type.

Accepted Answer

A)  Line 
B)  Column 
C)  Area 
D)  all of the above 
A)  Line 
B)  Column 
C)  Area 
D)  all of the above

Question 2

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 3

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 4

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

Accepted Answer

Data Label

Question 5

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 6

When a chart is selected, two contextual chart tools appear on the ribbon, and they do NOT include ____.

Accepted Answer

A)  DESIGN 
B)  FORMAT 
C)  EDIT 
D)  neither b nor c 
A)  DESIGN 
B)  FORMAT 
C)  EDIT 
D)  neither b nor c

Question 7

Case-Based Critical Thinking Questions
Case 3-1
   
Column Chart Area Chart
Sarah has put together the same information in two different charts, shown in the figure above, to present to her boss. She is thinking through the pros and cons of each chart type.
-Which chart does a better job of illustrating the collective sales trend in the Equipment, Footwear, and Apparel categories over the eight years?

Accepted Answer

A)  the column chart 
B)  the area chart 
C)  both a and b equally 
D)  neither a nor b does a good job 
A)  the column chart 
B)  the area chart 
C)  both a and b equally 
D)  neither a nor b does a good job

Question 8

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 9

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

Accepted Answer

A)  LAYOUT 
B)  FORMAT 
C)  EDIT 
D)  DESIGN 
A)  LAYOUT 
B)  FORMAT 
C)  EDIT 
D)  DESIGN

Question 10

Charts can be embedded as a(n) ____ on the same worksheet as the source data for the chart.

Accepted Answer

A)  function 
B)  icon 
C)  comment 
D)  object 
A)  function 
B)  icon 
C)  comment 
D)  object

____ charts all have a stacked chart sub-type.

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

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

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

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

When a chart is selected, two contextual chart tools appear on the ribbon, and they do NOT include ____.

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

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

Charts can be embedded as a(n) ____ on the same worksheet as the source data for the 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

____ charts all have a stacked chart sub-type.

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

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

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

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

When a chart is selected, two contextual chart tools appear on the ribbon, and they do NOT include ____.

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

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

Charts can be embedded as a(n) ____ on the same worksheet as the source data for the 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