Question 1

A ____ is a box that identifies the patterns or colors assigned to the data series in a chart.

Accepted Answer

A)  data series 
B)  data point 
C)  legend 
D)  chart title 
A)  data series 
B)  data point 
C)  legend 
D)  chart title

Question 2

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to drag individual pie segments between the two charts so you can include exactly the segments you want in the main pie chart and the second plot.

Accepted Answer

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

Question 3

You can modify the location of a chart at any time using the _____ dialog box.

Accepted Answer

A)  Modify Chart 
B)  Move Chart 
C)  Chart Elements 
D)  Edit Chart 
A)  Modify Chart 
B)  Move Chart 
C)  Chart Elements 
D)  Edit Chart

Question 4

Bar and column charts are commonly used to compare values across categories.

Accepted Answer

A) True 
 B)False

Question 5

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.
-Ross discovers a second way to change the rows and columns without opening a dialog box: He simply clicks the Switch Row/Column button in the Data group on the ____ tab.

Accepted Answer

A)  CHART EDIT 
B)  CHART INSERT 
C)  CHART FORMAT 
D)  CHART TOOLS FORMAT 
A)  CHART EDIT 
B)  CHART INSERT 
C)  CHART FORMAT 
D)  CHART TOOLS FORMAT

Question 6

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

Accepted Answer

Perspectiv

Question 7

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

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 8

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

Accepted Answer

A)  up bar 
B)  raise bar 
C)  increase bar 
D)  rich bar 
A)  up bar 
B)  raise bar 
C)  increase bar 
D)  rich bar

Question 9

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

Accepted Answer

The answer of The groundbreaking book by Edward R. ____________________,...

Question 10

____ of the chart types have 3-D options, but these should be used with caution.

Accepted Answer

A)  Few 
B)  Most 
C)  Only one 
D)  All 
A)  Few 
B)  Most 
C)  Only one 
D)  All

Question 11

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

Accepted Answer

The answer of In the Format Data Labels task pane,...

Question 12

Stacked charts do a good job of illustrating the ____ effects of data in categories.

Accepted Answer

A)  cumulative 
B)  individual 
C)  long-term 
D)  short-term 
A)  cumulative 
B)  individual 
C)  long-term 
D)  short-term

Question 13

____ is a part of the chart that decorates more than informs.

Accepted Answer

A)  Non-data-ink 
B)  Data-ink 
C)  Legend-ink 
D)  none of the above 
A)  Non-data-ink 
B)  Data-ink 
C)  Legend-ink 
D)  none of the above

Question 14

Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

Accepted Answer

A) True 
 B)False

Question 15

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

Accepted Answer

A)  on the worksheet with its data 
B)  on a worksheet separate from its data 
C)  in a new file 
D)  in separate workbooks 
A)  on the worksheet with its data 
B)  on a worksheet separate from its data 
C)  in a new file 
D)  in separate workbooks

Question 16

The ____ gallery in the Insert Shapes group on the CHART TOOLS FORMAT tab contains a variety of shapes that can be added to a chart.

Accepted Answer

A)  Shapes 
B)  Icons 
C)  Borders 
D)  Paint 
A)  Shapes 
B)  Icons 
C)  Borders 
D)  Paint

Question 17

To create a forward forecast in Excel, adding a ____ to a chart may reveal trends in the data.

Accepted Answer

A)  linear trendline 
B)  sparkline 
C)  stock volume 
D)  stock price 
A)  linear trendline 
B)  sparkline 
C)  stock volume 
D)  stock price

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Layered charts are known for doing a good job of illustrating the cumulative effects of data in categories. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

A ____ is a box that identifies the patterns or colors assigned to the data series in a chart.

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to drag individual pie segments between the two charts so you can include exactly the segments you want in the main pie chart and the second plot.

You can modify the location of a chart at any time using the _____ dialog box.

Bar and column charts are commonly used to compare values across categories.

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

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

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

____ of the chart types have 3-D options, but these should be used with caution.

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

Stacked charts do a good job of illustrating the ____ effects of data in categories.

____ is a part of the chart that decorates more than informs.

Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

The ____ gallery in the Insert Shapes group on the CHART TOOLS FORMAT tab contains a variety of shapes that can be added to a chart.

To create a forward forecast in Excel, adding a ____ to a chart may reveal trends in the data.

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

Layered charts are known for doing a good job of illustrating the cumulative effects of data in categories. _________________________

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

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 ____ is a box that identifies the patterns or colors assigned to the data series in a chart.

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to drag individual pie segments between the two charts so you can include exactly the segments you want in the main pie chart and the second plot.

You can modify the location of a chart at any time using the _____ dialog box.

Bar and column charts are commonly used to compare values across categories.

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

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

In the Open-High-Low-Close chart sub-type, if the box is white, the stock increased in value for the time period. The white box is referred to as the ____.

The groundbreaking book by Edward R. ____________________, The Visual Display of Quantitative Information, gave advice such as "Above all else show the data."

____ of the chart types have 3-D options, but these should be used with caution.

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

Stacked charts do a good job of illustrating the ____ effects of data in categories.

____ is a part of the chart that decorates more than informs.

Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

The ____ gallery in the Insert Shapes group on the CHART TOOLS FORMAT tab contains a variety of shapes that can be added to a chart.

To create a forward forecast in Excel, adding a ____ to a chart may reveal trends in the data.

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

Layered charts are known for doing a good job of illustrating the cumulative effects of data in categories. _________________________

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

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