Question 1

To reposition the legend to the left-hand side of a chart,click the _________ button,point to Legend,click the right arrow icon,and click Left.

Accepted Answer

A) Legend 
B) Chart Elements 
C) Formatting 
D) Layout 
A) Legend 
B) Chart Elements 
C) Formatting 
D) Layout B

Question 2

Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

Accepted Answer

A) line chart 
B) exploded pie chart 
C) scatter chart 
D) banded chart 
A) line chart 
B) exploded pie chart 
C) scatter chart 
D) banded chart B

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

Accepted Answer

A) INSERT and DESIGN 
B) DESIGN and FORMAT 
C) INSERT and FORMAT 
D) FORMAT and PRINT 
A) INSERT and DESIGN 
B) DESIGN and FORMAT 
C) INSERT and FORMAT 
D) FORMAT and PRINT

Question 5

You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________

Accepted Answer

A) True 
 B)False

Question 6

The cell with the largest value contains a 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 7

Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

Accepted Answer

A) search 
B) filter 
C) find 
D) examine 
A) search 
B) filter 
C) find 
D) examine

Question 8

It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

Accepted Answer

A) a legend 
B) major tick marks 
C) colors 
D) more numbers 
A) a legend 
B) major tick marks 
C) colors 
D) more numbers

Question 9

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 10

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

Accepted Answer

Answers will vary.Students should cover

Question 11

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 12

The range of values,or ___________________,of an axis is based on the values in the data source.

Accepted Answer

The answer of The range of values,or ___________________,of an axis...

Question 13

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

Each slice in a pie chart represents a single value from a data series.____________

Accepted Answer

A) True 
 B)False

Question 15

Category values are usually located in the ____ of the data source.

Accepted Answer

A) first row 
B) first column 
C) either a or b 
D) neither a nor b 
A) first row 
B) first column 
C) either a or b 
D) neither a nor b

Question 16

A chart sheet can contain ____.

Accepted Answer

A) only one chart 
B) one or two charts 
C) one to four charts 
D) one to six charts 
A) only one chart 
B) one or two charts 
C) one to four charts 
D) one to six charts

Question 17

An _______ chart takes up less space than a chart sheet.

Accepted Answer

The answer of An _______ chart takes up less space...

Question 18

The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.

Accepted Answer

The answer of The _______ covers the entire background of...

Question 19

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 20

____provide descriptive text for the individual data markers,such as pie slices

Accepted Answer

A) Asset labels 
B) Legend values 
C) Data labels 
D) Leader lines 
A) Asset labels 
B) Legend values 
C) Data labels 
D) Leader lines

To reposition the legend to the left-hand side of a chart,click the _________ button,point to Legend,click the right arrow icon,and click Left.

Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

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

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________

The cell with the largest value contains a 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._________________________

Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

In the figure above,nper stands for the ____.

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

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

The range of values,or ___________________,of an axis is based on the values in the data source.

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?

Each slice in a pie chart represents a single value from a data series.____________

Category values are usually located in the ____ of the data source.

A chart sheet can contain ____.

An _______ chart takes up less space than a chart sheet.

The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.

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.

____provide descriptive text for the individual data markers,such as pie slices

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Internet Basics and Information Literacy

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 10: Analyzing and Charting Financial Data

To reposition the legend to the left-hand side of a chart,click the _________ button,point to Legend,click the right arrow icon,and click Left.

Mya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

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

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________

The cell with the largest value contains a 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._________________________

Sometimes Mya might want to see information on only specific slices.Rather than creating a new chart that includes only those selections,she can _____ an existing chart.

It's difficult to read the exact scale on some of Simon's data.Adding ____ would make it easier to read.

In the figure above,nper stands for the ____.

Consider the impact of a poorly designed chart.Explain why it is important to have a well-designed chart,and name at least four tips for creating a good chart.

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

The range of values,or ___________________,of an axis is based on the values in the data source.

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?

Each slice in a pie chart represents a single value from a data series.____________

Category values are usually located in the ____ of the data source.

A chart sheet can contain ____.

An _______ chart takes up less space than a chart sheet.

The _______ covers the entire background of the chart,whereas the plot area includes only that portion of the chart in which the data markers,such as the columns in a column chart,have been placed or plotted.

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.

____provide descriptive text for the individual data markers,such as pie slices

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Internet Basics and Information Literacy

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