Question 1

A(n) ____ chart plots numeric values on both the x- and y-axes based on the value of the data.

Accepted Answer

A)  X Y (Scatter) 
B)  line 
C)  column 
D)  bar 
A)  X Y (Scatter) 
B)  line 
C)  column 
D)  bar

Question 2

Identify the letter of the choice that best matches the phrase or definition.
-Bar chart type

Accepted Answer

A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category 
A) Compares values across categories in a vertical orientation 
B) Compares the contribution each value in a multiple numeric data series makes to the whole, or 100% 
C) Compares values across categories in a horizontal orientation 
D) Displays trends over time or by category

Question 3

To change the chart sub-type, click the Change Chart Type button in the ____ group on the CHART TOOLS DESIGN tab.

Accepted Answer

A)  Type 
B)  Chart 
C)  Design 
D)  Format 
A)  Type 
B)  Chart 
C)  Design 
D)  Format

Question 4

The column chart's default column chart sub-type is the _____ sub-type.

Accepted Answer

A)  stacked 
B)  clustered 
C)  high-low 
D)  3-D 
A)  stacked 
B)  clustered 
C)  high-low 
D)  3-D

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Tufte's first principle, "Above all else show the data," is a reminder to show as large a range of data as possible.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

Accepted Answer

The answer of Microsoft Excel can be used to provide...

Question 10

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 11

A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________

Accepted Answer

A) True 
 B)False

Question 12

As a general rule, you should place charts that are developed for presentation and printing on a chart sheet.

Accepted Answer

A) True 
 B)False

Question 13

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

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 14

Using the ____ in a chart is a common way to include widely differing sets of data from the same time period.

Accepted Answer

A)  secondary axis 
B)  primary axis 
C)  moving average 
D)  scatter feature 
A)  secondary axis 
B)  primary axis 
C)  moving average 
D)  scatter feature

Question 15

When tracking stock prices, the term crawling average is used because the average is calculated each day for the last 30 days-moving the average along the chart.
_________________________

Accepted Answer

A) True 
 B)False

Question 16

In a(n) ____ chart, values are indicated by the height of the columns.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

To create a chart in Excel, you first select the data you want to display in the chart, and then click the ____ tab on the ribbon.

Accepted Answer

A)  VIEW 
B)  FORMULAS 
C)  DATA 
D)  INSERT 
A)  VIEW 
B)  FORMULAS 
C)  DATA 
D)  INSERT

Question 19

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

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

Radar charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle. _________________________

Accepted Answer

A) True 
 B)False

A(n) ____ chart plots numeric values on both the x- and y-axes based on the value of the data.

Identify the letter of the choice that best matches the phrase or definition. -Bar chart type

To change the chart sub-type, click the Change Chart Type button in the ____ group on the CHART TOOLS DESIGN tab.

The column chart's default column chart sub-type is the _____ sub-type.

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.

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

Tufte's first principle, "Above all else show the data," is a reminder to show as large a range of data as possible.

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

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

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

A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________

As a general rule, you should place charts that are developed for presentation and printing on a chart sheet.

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

Using the ____ in a chart is a common way to include widely differing sets of data from the same time period.

When tracking stock prices, the term crawling average is used because the average is calculated each day for the last 30 days-moving the average along the chart. _________________________

In a(n) ____ chart, values are indicated by the height of the columns.

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

To create a chart in Excel, you first select the data you want to display in the chart, and then click the ____ tab on the ribbon.

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

Radar charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle. _________________________

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(n) ____ chart plots numeric values on both the x- and y-axes based on the value of the data.

Identify the letter of the choice that best matches the phrase or definition. -Bar chart type

To change the chart sub-type, click the Change Chart Type button in the ____ group on the CHART TOOLS DESIGN tab.

The column chart's default column chart sub-type is the _____ sub-type.

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.

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

Tufte's first principle, "Above all else show the data," is a reminder to show as large a range of data as possible.

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

Microsoft Excel can be used to provide a visual representation of ____________________ information, giving the viewer an overall picture of a set of data.

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

A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________

As a general rule, you should place charts that are developed for presentation and printing on a chart sheet.

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

Using the ____ in a chart is a common way to include widely differing sets of data from the same time period.

When tracking stock prices, the term crawling average is used because the average is calculated each day for the last 30 days-moving the average along the chart. _________________________

In a(n) ____ chart, values are indicated by the height of the columns.

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

To create a chart in Excel, you first select the data you want to display in the chart, and then click the ____ tab on the ribbon.

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

Radar charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle. _________________________

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