Question 1

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 2

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 3

Interest is the amount added to the principal by the lender._________________________

Accepted Answer

A) True 
 B)False

Question 4

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 5

Since it's important for Mya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Mya? _____

Accepted Answer

A) bar 
B) column 
C) scatter 
D) pie 
A) bar 
B) column 
C) scatter 
D) pie

Question 6

Interest is the amount of money being loaned.___________

Accepted Answer

A) True 
 B)False

Question 7

A ____________ displays data values as columns with the height of each column based on the data value.

Accepted Answer

The answer of A ____________ displays data values as columns...

Question 8

The ____ identifies which data markers are associated with each data series.

Accepted Answer

A) x-axis 
B) y-axis 
C) chart area 
D) legend 
A) x-axis 
B) y-axis 
C) chart area 
D) legend

Question 9

Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.

Accepted Answer

XY scatter

Question 10

A chart that compares three set of values in a three-dimensional chart is _____.

Accepted Answer

A) Stock 
B) Radar 
C) Surface 
D) Scatter 
A) Stock 
B) Radar 
C) Surface 
D) Scatter

Question 11

Excel charts are either placed in their own chart sheets or embedded in a worksheet.____________

Accepted Answer

A) True 
 B)False

Question 12

Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

Accepted Answer

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

Question 13

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 14

Since Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

Accepted Answer

A) paste her chart in as a picture 
B) do nothing since charts in Excel remain linked to data sources 
C) manually adjust data in a chart 
D) create a new chart each time she modifies her data 
A) paste her chart in as a picture 
B) do nothing since charts in Excel remain linked to data sources 
C) manually adjust data in a chart 
D) create a new chart each time she modifies her data

Question 15

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 16

In the figure above,pv stands for the ____.

Accepted Answer

A) payments verified 
B) principal value of the loan 
C) present value of the loan 
D) primary interest rate of the loan 
A) payments verified 
B) principal value of the loan 
C) present value of the loan 
D) primary interest rate of the loan

Question 17

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 18

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

Accepted Answer

The answer of Each data source is a collection of...

Question 19

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

Accepted Answer

A) CHART TOOLS LAYOUT 
B) CHART TOOLS DESIGN 
C) INSERT 
D) HOME 
A) CHART TOOLS LAYOUT 
B) CHART TOOLS DESIGN 
C) INSERT 
D) HOME

Question 20

By default,Excel inserts a chart as an embedded chart._________________________

Accepted Answer

A) True 
 B)False

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

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

Interest is the amount added to the principal by the lender._________________________

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.

Since it's important for Mya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Mya? _____

Interest is the amount of money being loaned.___________

A ____________ displays data values as columns with the height of each column based on the data value.

The ____ identifies which data markers are associated with each data series.

Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.

A chart that compares three set of values in a three-dimensional chart is _____.

Excel charts are either placed in their own chart sheets or embedded in a worksheet.____________

Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

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.

Since Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

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

In the figure above,pv stands for the ____.

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

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

By default,Excel inserts a chart as an embedded chart._________________________

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

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

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

Interest is the amount added to the principal by the lender._________________________

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.

Since it's important for Mya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Mya? _____

Interest is the amount of money being loaned.___________

A ____________ displays data values as columns with the height of each column based on the data value.

The ____ identifies which data markers are associated with each data series.

Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.

A chart that compares three set of values in a three-dimensional chart is _____.

Excel charts are either placed in their own chart sheets or embedded in a worksheet.____________

Simon wants to change the chart's border.To do this,he should select the CHART TOOLS ____ tab.

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.

Since Mya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

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

In the figure above,pv stands for the ____.

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

Each data source is a collection of ____________________,which is a range of values plotted as a single unit on a chart.

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

By default,Excel inserts a chart as an embedded chart._________________________

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