Question 1

The Description options on the Chart Elements menu control the display and placement of the chart legend.

Accepted Answer

A) True 
 B)False

Question 2

The ____ trendline is used to smooth out the data, making it easier to spot trends.

Accepted Answer

A)  average 
B)  moving average 
C)  smooth average 
D)  trial 
A)  average 
B)  moving average 
C)  smooth average 
D)  trial

Question 3

An Excel chart requires ____ numeric data series in one chart.

Accepted Answer

A)  two or more 
B)  at least one 
C)  x and y 
D)  none of the above; the number of data series and data points that Excel requires in a chart is only limited by the available computer memory and capacity 
A)  two or more 
B)  at least one 
C)  x and y 
D)  none of the above; the number of data series and data points that Excel requires in a chart is only limited by the available computer memory and capacity

Question 4

Data series are points in a data set at which the x-axis and y-axis values intersect.

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.
-When the chart is plotted by rows, 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 6

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.
-If Sarah wanted to focus on and display the percentage contribution that each category makes to the whole, which chart type would work best?

Accepted Answer

A)  surface 
B)  pie 
C)  scatter 
D)  radar 
A)  surface 
B)  pie 
C)  scatter 
D)  radar

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.
-An area chart combines the features of a ____ by filling in the area below the line, and displaying the trend of values over time or categories.

Accepted Answer

A)  line chart with a bar or column chart 
B)  bar chart with a column chart 
C)  scatter chart with a radar chart 
D)  bubble chart with a surface chart 
A)  line chart with a bar or column chart 
B)  bar chart with a column chart 
C)  scatter chart with a radar chart 
D)  bubble chart with a surface chart

Question 8

The Format Axis task pane allows you to control ____.

Accepted Answer

A)  axes 
B)  gridlines 
C)  both a and b 
D)  neither a nor b 
A)  axes 
B)  gridlines 
C)  both a and b 
D)  neither a nor b

Question 9

In the Format Data Labels task pane, use the options in the ____ category to specify the alignment (horizontal or vertical), orientation, position, and direction of the data labels.

Accepted Answer

A)  Alignment 
B)  Size & Properties 
C)  Label Options 
D)  Effects 
A)  Alignment 
B)  Size & Properties 
C)  Label Options 
D)  Effects

Question 10

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

Accepted Answer

The answer of The ____________________ dialog box, which is available...

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-Doughnut 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 12

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

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 13

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

Accepted Answer

The answer of A(n) ____________________ combines the features of a...

Question 14

To compare the contribution each value in a single data series makes to the whole, or 100%, use a pie chart.

Accepted Answer

A) True 
 B)False

Question 15

The pie chart has two chart sub-types, ____ and Bar of Pie, which are smaller charts that are displayed next to the original chart.

Accepted Answer

A)  Pie of Pie 
B)  Column of Pie 
C)  Line of Pie 
D)  Table of Pie 
A)  Pie of Pie 
B)  Column of Pie 
C)  Line of Pie 
D)  Table of Pie

Question 16

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

Accepted Answer

The answer of To change the chart sub-type, click the...

Question 17

In the ____ chart type, values are indicated by areas with colors or patterns on the surface of the chart.

Accepted Answer

A)  pattern 
B)  surface 
C)  scatter 
D)  doughnut 
A)  pattern 
B)  surface 
C)  scatter 
D)  doughnut

Question 18

The ____ chart sub-type adds information on the opening price of the stock to the High-Low-Close information for the time period.

Accepted Answer

A)  Open-High-Low-Close 
B)  High-Low-Close-Open 
C)  either a or b 
D)  neither a nor b 
A)  Open-High-Low-Close 
B)  High-Low-Close-Open 
C)  either a or b 
D)  neither a nor b

Question 19

____ charts allow three-dimensional data to be plotted in 2-D on two axes.

Accepted Answer

A)  Radar 
B)  Bubble 
C)  Doughnut 
D)  Scatter 
A)  Radar 
B)  Bubble 
C)  Doughnut 
D)  Scatter

Question 20

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

Accepted Answer

A)  Radar 
B)  Air traffic controller 
C)  NASA 
D)  Doppler 
A)  Radar 
B)  Air traffic controller 
C)  NASA 
D)  Doppler

The Description options on the Chart Elements menu control the display and placement of the chart legend.

The ____ trendline is used to smooth out the data, making it easier to spot trends.

An Excel chart requires ____ numeric data series in one chart.

Data series are points in a data set at which the x-axis and y-axis values intersect.

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 rows, what information does it emphasize?

The Format Axis task pane allows you to control ____.

In the Format Data Labels task pane, use the options in the ____ category to specify the alignment (horizontal or vertical), orientation, position, and direction of the data labels.

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

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

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

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

To compare the contribution each value in a single data series makes to the whole, or 100%, use a pie chart.

The pie chart has two chart sub-types, ____ and Bar of Pie, which are smaller charts that are displayed next to the original chart.

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

In the ____ chart type, values are indicated by areas with colors or patterns on the surface of the chart.

The ____ chart sub-type adds information on the opening price of the stock to the High-Low-Close information for the time period.

____ charts allow three-dimensional data to be plotted in 2-D on two axes.

____ 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

The Description options on the Chart Elements menu control the display and placement of the chart legend.

The ____ trendline is used to smooth out the data, making it easier to spot trends.

An Excel chart requires ____ numeric data series in one chart.

Data series are points in a data set at which the x-axis and y-axis values intersect.

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 rows, what information does it emphasize?

The Format Axis task pane allows you to control ____.

In the Format Data Labels task pane, use the options in the ____ category to specify the alignment (horizontal or vertical), orientation, position, and direction of the data labels.

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

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

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

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

To compare the contribution each value in a single data series makes to the whole, or 100%, use a pie chart.

The pie chart has two chart sub-types, ____ and Bar of Pie, which are smaller charts that are displayed next to the original chart.

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

In the ____ chart type, values are indicated by areas with colors or patterns on the surface of the chart.

The ____ chart sub-type adds information on the opening price of the stock to the High-Low-Close information for the time period.

____ charts allow three-dimensional data to be plotted in 2-D on two axes.

____ 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