Question 1

____ got their name because they display performance indicators in a fashion similar to the instrument panel in a car's dashboard.

Accepted Answer

A)  Management dashboards 
B)  Management instrument panels 
C)  Management speedways 
D)  Management control centers 
A)  Management dashboards 
B)  Management instrument panels 
C)  Management speedways 
D)  Management control centers

Question 2

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

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

Accepted Answer

The answer of The ____________________ chart type compares sets of...

Question 4

Many element-related Excel chart options are found on the Chart ____________________ menu.

Accepted Answer

The answer of Many element-related Excel chart options are found...

Question 5

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

Accepted Answer

The answer of To emphasize categories of data and each...

Question 6

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 7

In a worksheet, you can add up the stock traded during the month by using the ADD function.
_________________________

Accepted Answer

A) True 
 B)False

Question 8

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 9

By Columns By Rows
   
Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure.
-To create the comparison shown in the above figure, Ross used the Switch Row/Column button in the ____ group.

Accepted Answer

A)  Data 
B)  Type 
C)  Location 
D)  Chart Layouts 
A)  Data 
B)  Type 
C)  Location 
D)  Chart Layouts

Question 10

The ____ is the vertical axis where data values 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

According to Tufte, ____ can make charts difficult to read, use, and interpret.

Accepted Answer

A)  data ink 
B)  chart legends 
C)  chart junk 
D)  chart labels 
A)  data ink 
B)  chart legends 
C)  chart junk 
D)  chart labels

Question 12

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 13

Use a pie chart when it's most important to show relative percentages rather than values.

Accepted Answer

A) True 
 B)False

Question 14

By Columns By Rows
   
Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure.
-When the chart is plotted by columns, what information does it emphasize?

Accepted Answer

A)  comparing the amount of each year's sales for each of the three categories 
B)  the contribution that each category made to each year's performance 
C)  the percentage of total sales that each of the three categories make up 
D)  none of the above 
A)  comparing the amount of each year's sales for each of the three categories 
B)  the contribution that each category made to each year's performance 
C)  the percentage of total sales that each of the three categories make up 
D)  none of the above

Question 15

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

Accepted Answer

A) True 
 B)False

Question 16

Use the Trendline options on the Chart Elements menu to specify whether the x- and y-axes are displayed.

Accepted Answer

A) True 
 B)False

Question 17

In business, charts are typically used to summarize information so that it can be used by one person making a decision.

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

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 20

The Switch Row/Column button provides settings for swapping a data series between rows or columns.

Accepted Answer

A) True 
 B)False

____ got their name because they display performance indicators in a fashion similar to the instrument panel in a car's dashboard.

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

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

Many element-related Excel chart options are found on the Chart ____________________ menu.

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

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.

In a worksheet, you can add up the stock traded during the month by using the ADD function. _________________________

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

By Columns By Rows Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure. -To create the comparison shown in the above figure, Ross used the Switch Row/Column button in the ____ group.

The ____ is the vertical axis where data values are plotted.

According to Tufte, ____ can make charts difficult to read, use, and interpret.

The ____ is the horizontal axis where categories are plotted.

Use a pie chart when it's most important to show relative percentages rather than values.

By Columns By Rows Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure. -When the chart is plotted by columns, what information does it emphasize?

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

Use the Trendline options on the Chart Elements menu to specify whether the x- and y-axes are displayed.

In business, charts are typically used to summarize information so that it can be used by one person making a decision.

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

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

The Switch Row/Column button provides settings for swapping a data series between rows or columns.

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

____ got their name because they display performance indicators in a fashion similar to the instrument panel in a car's dashboard.

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

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

Many element-related Excel chart options are found on the Chart ____________________ menu.

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

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.

In a worksheet, you can add up the stock traded during the month by using the ADD function. _________________________

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

The ____ is the vertical axis where data values are plotted.

According to Tufte, ____ can make charts difficult to read, use, and interpret.

The ____ is the horizontal axis where categories are plotted.

Use a pie chart when it's most important to show relative percentages rather than values.

By Columns By Rows Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure. -When the chart is plotted by columns, what information does it emphasize?

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

Use the Trendline options on the Chart Elements menu to specify whether the x- and y-axes are displayed.

In business, charts are typically used to summarize information so that it can be used by one person making a decision.

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

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

The Switch Row/Column button provides settings for swapping a data series between rows or columns.

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