Question 1

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

Accepted Answer

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

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

To move one slice of a pie chart away from the pie creates a(n) ____.

Accepted Answer

A)  spontaneous pie chart 
B)  perfect pie chart 
C)  exploded pie chart 
D)  exponential pie chart 
A)  spontaneous pie chart 
B)  perfect pie chart 
C)  exploded pie chart 
D)  exponential pie chart

Question 5

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

Question 6

-Referring to the figure above, the rectangular area to the right of the pie chart is the ____.

Accepted Answer

A)  perspective 
B)  plot area 
C)  legend 
D)  data marker 
A)  perspective 
B)  plot area 
C)  legend 
D)  data marker

Question 7

Describe the some of the concepts and definitions associated with loans before using a PMT function.

Accepted Answer

The cost of a loan to the borrower is la

Question 8

Every chart contains elements that can be formatted, added to the chart, or removed
from the chart.

Accepted Answer

A) True 
 B)False

Question 9

______ are horizontal and vertical lines that help you compare data and category
values.

Accepted Answer

The answer of ______ are horizontal and vertical lines that...

Question 10

-In the lower right corner, below C34, the _____ tool displays.

Accepted Answer

A)  Screen Tip 
B)  Quick Analysis 
C)  What-If 
D)  Quick Chart 
A)  Screen Tip 
B)  Quick Analysis 
C)  What-If 
D)  Quick Chart

Question 11

Which of the following represents the pointer when it is over the chart area?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 12

-Referring to the figure above, the entry 31.5%, shown next to the largest pie slice, is a ____.

Accepted Answer

A)  data label 
B)  chart key 
C)  legend 
D)  series value 
A)  data label 
B)  chart key 
C)  legend 
D)  series value

Question 13

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 14

The amount of money being loaned is known as the ____.

Accepted Answer

A)  mortgage 
B)  principal 
C)  loan amount 
D)  proposed principal 
A)  mortgage 
B)  principal 
C)  loan amount 
D)  proposed principal

Question 15

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

The answer of MATCHING
Identify the letter of the chart type...

Question 16

In the figure above, nper stands for the ____.

Accepted Answer

A)  total number of payment periods 
B)  total number of payments that have already been made 
C)  number of payments per year 
D)  number of interest payments per year 
A)  total number of payment periods 
B)  total number of payments that have already been made 
C)  number of payments per year 
D)  number of interest payments per year

Question 17

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 18

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery. _________________________

Accepted Answer

A) True 
 B)False

Question 19

In a line chart, the data markers are the points connected by the line. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The goal of a ______ is to convey the maximum amount of information within a very small space.

Accepted Answer

The answer of The goal of a ______ is to...

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

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

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

To move one slice of a pie chart away from the pie creates a(n) ____.

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.

-Referring to the figure above, the rectangular area to the right of the pie chart is the ____.

Describe the some of the concepts and definitions associated with loans before using a PMT function.

Every chart contains elements that can be formatted, added to the chart, or removed from the chart.

______ are horizontal and vertical lines that help you compare data and category values.

-In the lower right corner, below C34, the _____ tool displays.

Which of the following represents the pointer when it is over the chart area?

-Referring to the figure above, the entry 31.5%, shown next to the largest pie slice, is a ____.

The amount of money being loaned is known as the ____.

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

In the figure above, nper stands for the ____.

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

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery. _________________________

In a line chart, the data markers are the points connected by the line. _________________________

The goal of a ______ is to convey the maximum amount of information within a very small space.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 9: Analyzing and Charting Financial Data

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

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

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

To move one slice of a pie chart away from the pie creates a(n) ____.

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.

-Referring to the figure above, the rectangular area to the right of the pie chart is the ____.

Describe the some of the concepts and definitions associated with loans before using a PMT function.

Every chart contains elements that can be formatted, added to the chart, or removed from the chart.

______ are horizontal and vertical lines that help you compare data and category values.

-In the lower right corner, below C34, the _____ tool displays.

Which of the following represents the pointer when it is over the chart area?

-Referring to the figure above, the entry 31.5%, shown next to the largest pie slice, is a ____.

The amount of money being loaned is known as the ____.

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

In the figure above, nper stands for the ____.

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

You can quickly change the appearance of the entire chart by selecting a different chart style in the Chart Design gallery. _________________________

In a line chart, the data markers are the points connected by the line. _________________________

The goal of a ______ is to convey the maximum amount of information within a very small space.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters