Question 1

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 2

A 100% stacked chart is similar to a ____ chart except that the pieces are in a column.

Accepted Answer

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

Question 3

Use the Label options on the Chart Elements menu to display a table of values for each data series in a grid below the chart. _________________________

Accepted Answer

A) True 
 B)False

Question 4

Generally, when a stock price moves above the moving average trendline, it is a good indicator
Of ____.

Accepted Answer

A)  a downward trend 
B)  an upward trend 
C)  a mistake in the data 
D)  baseline regression 
A)  a downward trend 
B)  an upward trend 
C)  a mistake in the data 
D)  baseline regression

Question 5

A ____ is a word-sized chart embedded in context with the data it represents.

Accepted Answer

A)  chart sub-type 
B)  line chart 
C)  chart 
D)  sparkline 
A)  chart sub-type 
B)  line chart 
C)  chart 
D)  sparkline

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart. ________________________

Accepted Answer

A) True 
 B)False

Question 8

One of the features of 100% stacked charts is that they show ____ percentages.

Accepted Answer

A)  cumulative 
B)  individual 
C)  average 
D)  linked 
A)  cumulative 
B)  individual 
C)  average 
D)  linked

Question 9

Doughnut charts are a way to show the information contained in a pie chart for ____.

Accepted Answer

A)  one series only 
B)  more than one series 
C)  totals more than 100% 
D)  none of the above 
A)  one series only 
B)  more than one series 
C)  totals more than 100% 
D)  none of the above

Question 10

List and explain briefly the five guidelines given by Edward R. Tufte.

Accepted Answer

1)Above all else show the data.
This is

Question 11

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.
-What is one of the weaknesses of the column chart shown above?

Accepted Answer

A)  too many columns 
B)  too few columns 
C)  inaccurate data 
D)  choice of x- and y-axis 
A)  too many columns 
B)  too few columns 
C)  inaccurate data 
D)  choice of x- and y-axis

Question 12

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 13

Radar charts are like area charts-but whereas area charts emphasize the amount of the contribution, radar charts emphasize ____.

Accepted Answer

A)  the high and low points of the data 
B)  moving averages 
C)  the trend in each category over time 
D)  the relative comparison of the categories 
A)  the high and low points of the data 
B)  moving averages 
C)  the trend in each category over time 
D)  the relative comparison of the categories

Question 14

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

Accepted Answer

The answer of An X Y (____________________) chart plots numeric...

Question 15

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

Accepted Answer

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

Question 16

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

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

Any changes to the data label content must be made using the Format Data Labels task pane. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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 19

Bubble charts allow three-dimensional data to be plotted in three dimensions on two axes. _________________________

Accepted Answer

A) True 
 B)False

Question 20

In a ____ chart, values are indicated by the distance from a center point.

Accepted Answer

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

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

A 100% stacked chart is similar to a ____ chart except that the pieces are in a column.

Use the Label options on the Chart Elements menu to display a table of values for each data series in a grid below the chart. _________________________

Generally, when a stock price moves above the moving average trendline, it is a good indicator Of ____.

A ____ is a word-sized chart embedded in context with the data it represents.

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

Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart. ________________________

One of the features of 100% stacked charts is that they show ____ percentages.

Doughnut charts are a way to show the information contained in a pie chart for ____.

List and explain briefly the five guidelines given by Edward R. Tufte.

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

Radar charts are like area charts-but whereas area charts emphasize the amount of the contribution, radar charts emphasize ____.

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

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

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

Any changes to the data label content must be made using the Format Data Labels task pane. _________________________

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

Bubble charts allow three-dimensional data to be plotted in three dimensions on two axes. _________________________

In a ____ chart, values 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

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

A 100% stacked chart is similar to a ____ chart except that the pieces are in a column.

Use the Label options on the Chart Elements menu to display a table of values for each data series in a grid below the chart. _________________________

Generally, when a stock price moves above the moving average trendline, it is a good indicator Of ____.

A ____ is a word-sized chart embedded in context with the data it represents.

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

Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart. ________________________

One of the features of 100% stacked charts is that they show ____ percentages.

Doughnut charts are a way to show the information contained in a pie chart for ____.

List and explain briefly the five guidelines given by Edward R. Tufte.

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

Radar charts are like area charts-but whereas area charts emphasize the amount of the contribution, radar charts emphasize ____.

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

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

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

Any changes to the data label content must be made using the Format Data Labels task pane. _________________________

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

Bubble charts allow three-dimensional data to be plotted in three dimensions on two axes. _________________________

In a ____ chart, values 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