Question 1

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

Accepted Answer

A)  scale 
B)  defined range 
C)  series 
D)  length 
A)  scale 
B)  defined range 
C)  series 
D)  length

Question 2

The FV function stands for ____.

Accepted Answer

A)  function value 
B)  future value 
C)  financial value 
D)  formulated value 
A)  function value 
B)  future value 
C)  financial value 
D)  formulated value

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

____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

Question 5

In pie charts, it's best to make the slice colors as similar as possible.

Accepted Answer

A) True 
 B)False

Question 6

Pie charts are most effective with ten or fewer slices. _________________________

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Displays stock market data

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

In cases where a label placed outside a pie might appear farther from its slice than is easily readable, a(n) ____________________ might be added to connect the data to its corresponding slices.

Accepted Answer

The answer of In cases where a label placed outside...

Question 9

The possible values for the type argument in the function above are.

Accepted Answer

A)  0 or null 
B)  0 or 1 
C)  0, 1, or 2 
D)  0, 1, 2, or 3 
A)  0 or null 
B)  0 or 1 
C)  0, 1, or 2 
D)  0, 1, 2, or 3

Question 10

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Accepted Answer

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

Question 11

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories. Areas under the lines contain a fill color

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 12

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

Accepted Answer

A)  CREATE 
B)  VIEW 
C)  LAYOUT 
D)  DESIGN 
A)  CREATE 
B)  VIEW 
C)  LAYOUT 
D)  DESIGN

Question 13

Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________

Accepted Answer

A) True 
 B)False

Question 14

When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. _________________________

Accepted Answer

A) True 
 B)False

Question 15

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Similar to a Scatter 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 16

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

Accepted Answer

A)  data 
B)  non-data 
C)  information 
D)  non-information 
A)  data 
B)  non-data 
C)  information 
D)  non-information

Question 17

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

Accepted Answer

A)  espionage 
B)  clutter 
C)  confusion 
D)  junk 
A)  espionage 
B)  clutter 
C)  confusion 
D)  junk

Question 18

Excel supports all of the following types of sparklines EXCEPT ____.

Accepted Answer

A)  A win/loss sparkline for highlighting positive and negative values 
B)  A column sparkline used for column charts 
C)  A line sparkline for highlighting trends 
D)  a true/false sparkline for help making decisions 
A)  A win/loss sparkline for highlighting positive and negative values 
B)  A column sparkline used for column charts 
C)  A line sparkline for highlighting trends 
D)  a true/false sparkline for help making decisions

Question 19

A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value.

Accepted Answer

A) True 
 B)False

Question 20

When selecting a chart, it's important to choose the right type of chart to represent your data. If choosing between a pie chart and a line chart, what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

Accepted Answer

Answers will vary. Students should evide

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

The FV function stands for ____.

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

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

In pie charts, it's best to make the slice colors as similar as possible.

Pie charts are most effective with ten or fewer slices. _________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Displays stock market data

In cases where a label placed outside a pie might appear farther from its slice than is easily readable, a(n) ____________________ might be added to connect the data to its corresponding slices.

The possible values for the type argument in the function above are.

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories. Areas under the lines contain a fill color

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________

When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. _________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Similar to a Scatter chart

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

Excel supports all of the following types of sparklines EXCEPT ____.

A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value.

When selecting a chart, it's important to choose the right type of chart to represent your data. If choosing between a pie chart and a line chart, what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

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

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

The FV function stands for ____.

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

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

In pie charts, it's best to make the slice colors as similar as possible.

Pie charts are most effective with ten or fewer slices. _________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Displays stock market data

In cases where a label placed outside a pie might appear farther from its slice than is easily readable, a(n) ____________________ might be added to connect the data to its corresponding slices.

The possible values for the type argument in the function above are.

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories. Areas under the lines contain a fill color

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

Combination charts enable you to show three sets of data using the chart type that is best for each data set. _________________________

When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. _________________________

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Similar to a Scatter chart

Edward Tufte said that ____ ink is any part of the chart that does not convey information about the data.

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

Excel supports all of the following types of sparklines EXCEPT ____.

A column chart turned on its side is called a bar chart, with the length of the bar determined by the data value.

When selecting a chart, it's important to choose the right type of chart to represent your data. If choosing between a pie chart and a line chart, what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?

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