Question 1

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 2

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 3

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 4

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 5

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 6

In a ____ chart, values are indicated by the size of the slices.

Accepted Answer

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

Question 7

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 8

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 9

In a worksheet, the MAX and MIN functions can be used to take care of the highest and lowest stock price, respectively, for each month. _________________________

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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 13

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 14

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 15

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 16

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

Accepted Answer

A)  LAYOUT 
B)  FORMAT 
C)  EDIT 
D)  DESIGN 
A)  LAYOUT 
B)  FORMAT 
C)  EDIT 
D)  DESIGN

Question 17

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 18

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 19

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

Accepted Answer

The answer of The ____________________ is the descriptive text that...

Question 20

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

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

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

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

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

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

In a ____ chart, values are indicated by the size of the slices.

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

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

In a worksheet, the MAX and MIN functions can be used to take care of the highest and lowest stock price, respectively, for each month. _________________________

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

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

The Format Axis task pane allows you to control ____.

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. _________________________

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

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. ________________________

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

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

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

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

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

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 pie chart has two chart sub-types, ____ and Bar of Pie, which are smaller charts that are displayed next to the original chart.

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

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

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

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

In a ____ chart, values are indicated by the size of the slices.

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

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

In a worksheet, the MAX and MIN functions can be used to take care of the highest and lowest stock price, respectively, for each month. _________________________

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

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

The Format Axis task pane allows you to control ____.

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. _________________________

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

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. ________________________

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

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

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

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

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

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