Question 1

-Referring to the figure above,in the column chart,the values along the left side ($200,000,$400,000,$600,000,etc.)are ____.

Accepted Answer

A) plot markers 
B) plot marks 
C) data markers 
D) axis labels 
A) plot markers 
B) plot marks 
C) data markers 
D) axis labels

Question 2

____ is the amount added to the prinicpal of a loan by the lender.

Accepted Answer

A) Rate 
B) Simple 
C) Interest 
D) Maximum 
A) Rate 
B) Simple 
C) Interest 
D) Maximum

Question 3

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares three sets of values in a three-dimensional chart

Accepted Answer

A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area 
A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area

Question 4

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the length of the ____

Accepted Answer

A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area 
A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area

Question 5

Each value from a data series is represented by a ________.

Accepted Answer

The answer of Each value from a data series is...

Question 6

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

Accepted Answer

The answer of A(n)____________________ chart shows patterns or relationships between...

Question 7

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the height of each ____.

Accepted Answer

A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area 
A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area

Question 8

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.

Accepted Answer

A) True 
 B)False

Question 9

The cell with the largest value contains a $\underline {  \text { data marker }  }$that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________

Accepted Answer

A) True 
 B)False

Question 10

$\underline {  \text { Interest }  }$ is the amount added to the principal by the lender._________________________

Accepted Answer

A) True 
 B)False

Question 11

To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.

Accepted Answer

The answer of To compare values from several categories with...

Question 12

In a line chart,the $\underline {  \text { data marker }  }$ are the points connected by the line._________________________

Accepted Answer

A) True 
 B)False

Question 13

Generally,_____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

Accepted Answer

A) charts 
B) watermarks 
C) graphics 
D) pictures 
A) charts 
B) watermarks 
C) graphics 
D) pictures

Question 14

Simon has just started a job with the police department. His director has given him the last six months of test results from four local precincts. Simon has organized the results as four data series and needs to display the trends in a graphic format.
-Simon has finished his chart but needs to save some space.What's the most effective way for Andy to reduce space without losing important data?

Accepted Answer

A) Delete parts of the data 
B) Delete the legend 
C) Delete the title 
D) Overlay the legend in areas without data 
A) Delete parts of the data 
B) Delete the legend 
C) Delete the title 
D) Overlay the legend in areas without data

Question 15

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

Accepted Answer

A) Change Chart Type 
B) New Chart 
C) Alter Existing Chart 
D) Modify Chart 
A) Change Chart Type 
B) New Chart 
C) Alter Existing Chart 
D) Modify Chart

Question 16

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares a collection of values from several different data sets.

Accepted Answer

A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area 
A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area

Question 17

Interest is the amount of money being loaned.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following shows the correct order of steps for adding a data series to a chart?

Accepted Answer

A) Select the chart, Click the Add button, Click the Select Data button, Select the range 
B) Select the chart, Click the Select Data button, Click the Add button, Select the range 
C) Select the range, Click the Select Data button, Click the Add button, Select the chart 
D) Select the range, Select the chart, Click the Select Data button, Click the Add button 
A) Select the chart, Click the Add button, Click the Select Data button, Select the range 
B) Select the chart, Click the Select Data button, Click the Add button, Select the range 
C) Select the range, Click the Select Data button, Click the Add button, Select the chart 
D) Select the range, Select the chart, Click the Select Data button, Click the Add button

Question 19

Line charts are best suited for representing data that follows some nonsequential order.

Accepted Answer

A) True 
 B)False

Question 20

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Accepted Answer

A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area 
A) Scatter 
B) Column 
C) XY 
D) Line 
E) Radar
F)Pie
G)Stock
H)Bar
I)Surface
J)Area

-Referring to the figure above,in the column chart,the values along the left side ($200,000,$400,000,$600,000,etc.)are ____.

____ is the amount added to the prinicpal of a loan by the lender.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the length of the ____

Each value from a data series is represented by a ________.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the height of each ____.

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.

The cell with the largest value contains a $\underline { \text { data marker } }$ that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________

$\underline { \text { Interest } }$ is the amount added to the principal by the lender._________________________

To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.

In a line chart,the $\underline { \text { data marker } }$ are the points connected by the line._________________________

Generally,_____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares a collection of values from several different data sets.

Interest is the amount of money being loaned.

Which of the following shows the correct order of steps for adding a data series to a chart?

Line charts are best suited for representing data that follows some nonsequential order.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 4: Analyzing and Charting Financial Data

-Referring to the figure above,in the column chart,the values along the left side ($200,000,$400,000,$600,000,etc.)are ____.

____ is the amount added to the prinicpal of a loan by the lender.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the length of the ____

Each value from a data series is represented by a ________.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the height of each ____.

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent.

The cell with the largest value contains a data marker ‾\underline { \text { data marker } } data marker ​ that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________

Interest ‾\underline { \text { Interest } } Interest ​ is the amount added to the principal by the lender._________________________

To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.

In a line chart,the data marker ‾\underline { \text { data marker } } data marker ​ are the points connected by the line._________________________

Generally,_____ are given a "washed-out" appearance and are placed behind text or charts on the sheet so that they do not obscure any of the other content on the sheet.

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares a collection of values from several different data sets.

Interest is the amount of money being loaned.

Which of the following shows the correct order of steps for adding a data series to a chart?

Line charts are best suited for representing data that follows some nonsequential order.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

The cell with the largest value contains a $\underline { \text { data marker } }$ that extends across the entire width of the cell,and the lengths of the other bars in the selected range are determined relative to that bar._________________________

$\underline { \text { Interest } }$ is the amount added to the principal by the lender._________________________

In a line chart,the $\underline { \text { data marker } }$ are the points connected by the line._________________________