Question 1

The _______ function calculates the interest rate charged or received during each payment period.

Accepted Answer

A)  RATE 
B)  PV 
C)  NPER 
D)  FV 
A)  RATE 
B)  PV 
C)  NPER 
D)  FV

Question 2

If active cell D12 contains the formula =D10+D11,cells D10 and D11 are _______ cells for D12.

Accepted Answer

A)  feeder 
B)  dependent 
C)  precedent 
D)  formula 
A)  feeder 
B)  dependent 
C)  precedent 
D)  formula

Question 3

A(n)dependent cell is one whose value depends on the values of other cells in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 4

The _______ function calculates the amount paid into an investment or loan during each payment period.

Accepted Answer

A)  NPER 
B)  RATE 
C)  PMT 
D)  INT 
A)  NPER 
B)  RATE 
C)  PMT 
D)  INT

Question 5

The major advantage of the payback period is that it takes into account the time value of money.

Accepted Answer

A) True 
 B)False

Question 6

The _______ function takes only these arguments: cost,salvage,and life.

Accepted Answer

A)  SLN 
B)  SYD 
C)  DB 
D)  VDB 
A)  SLN 
B)  SYD 
C)  DB 
D)  VDB

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-Calculates a loan's future value

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function

Question 8

Case 9-2
Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation.
-Which of the following functions does Lisa say is used to calculate a straight-line depreciation?

Accepted Answer

A)  DB 
B)  SLN 
C)  SYD 
D)  DDB 
A)  DB 
B)  SLN 
C)  SYD 
D)  DDB

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Calculates the amount of a loan payment applied to the principal

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function

Question 10

The _______ function calculates the present value of an investment or loan.

Accepted Answer

A)  PRES 
B)  PV 
C)  NPER 
D)  FV 
A)  PRES 
B)  PV 
C)  NPER 
D)  FV

Question 11

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

Accepted Answer

A)  Asset Report 
B)  Income Statement 
C)  Balance Sheet 
D)  Transactions 
A)  Asset Report 
B)  Income Statement 
C)  Balance Sheet 
D)  Transactions

Question 12

Identify the letter of the choice that best matches the phrase or definition.
-Calculates the number of payments required to pay off a loan or reach an investment goal

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function

Question 13

To project a trend that decreases rather than increases,use a step value of less than _______ for a linear trend.

Accepted Answer

A)  -1 
B)  0 
C)  1 
D)  2 
A)  -1 
B)  0 
C)  1 
D)  2

Question 14

Seymour tells Charles to search all of the error values until he reaches one that lacks something,and that is the source of the error values in the dependent cells.What does that error value lack?

Accepted Answer

A)  contingencies 
B)  dependencies 
C)  antecedents 
D)  precedents 
A)  contingencies 
B)  dependencies 
C)  antecedents 
D)  precedents

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-Calculates the payment in each period required to pay off a loan or reach an investment goal

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function

Question 16

Most Excel financial functions require a particular _______ to the cash flow to return the correct value.

Accepted Answer

A)  index 
B)  valence 
C)  orientation 
D)  direction 
A)  index 
B)  valence 
C)  orientation 
D)  direction

Question 17

Financial functions format calculated values as currency,with _______.

Accepted Answer

A)  positive cash flow appearing in red font 
B)  positive cash flow enclosed in parentheses 
C)  negative cash flow appearing in green font 
D)  negative cash flow appearing in red font 
A)  positive cash flow appearing in red font 
B)  positive cash flow enclosed in parentheses 
C)  negative cash flow appearing in green font 
D)  negative cash flow appearing in red font

Question 18

Case 9-2
Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation.
-Which of the following functions does Lisa say is used to calculate a declining balance depreciation?

Accepted Answer

A)  DB 
B)  SLN 
C)  SYD 
D)  DDB 
A)  DB 
B)  SLN 
C)  SYD 
D)  DDB

Question 19

Identify the letter of the choice that best matches the phrase or definition.
-Calculates the per period interest rate required to pay off a loan or reach an investment goal

Accepted Answer

A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function 
A) PPMT function 
B) rate of return 
C) IPMT function 
D) IRR 
E) PV function
F)RATE function
G)PMT function
H)XIRR function
I)FV function
J)NPER function

Question 20

To _______ a series,the cells between the first and last cells in the series must be blank.

Accepted Answer

A)  extrapolate 
B)  concatenate 
C)  integrate 
D)  interpolate 
A)  extrapolate 
B)  concatenate 
C)  integrate 
D)  interpolate

The _______ function calculates the interest rate charged or received during each payment period.

If active cell D12 contains the formula =D10+D11,cells D10 and D11 are _______ cells for D12.

A(n)dependent cell is one whose value depends on the values of other cells in the workbook._________________________

The _______ function calculates the amount paid into an investment or loan during each payment period.

The major advantage of the payback period is that it takes into account the time value of money.

The _______ function takes only these arguments: cost,salvage,and life.

Identify the letter of the choice that best matches the phrase or definition. -Calculates a loan's future value

Case 9-2 Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a straight-line depreciation?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment applied to the principal

The _______ function calculates the present value of an investment or loan.

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

Identify the letter of the choice that best matches the phrase or definition. -Calculates the number of payments required to pay off a loan or reach an investment goal

To project a trend that decreases rather than increases,use a step value of less than _______ for a linear trend.

Seymour tells Charles to search all of the error values until he reaches one that lacks something,and that is the source of the error values in the dependent cells.What does that error value lack?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the payment in each period required to pay off a loan or reach an investment goal

Most Excel financial functions require a particular _______ to the cash flow to return the correct value.

Financial functions format calculated values as currency,with _______.

Case 9-2 Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a declining balance depreciation?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the per period interest rate required to pay off a loan or reach an investment goal

To _______ a series,the cells between the first and last cells in the series must be blank.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 9: Exploring Financial Tools and Functions

The _______ function calculates the interest rate charged or received during each payment period.

If active cell D12 contains the formula =D10+D11,cells D10 and D11 are _______ cells for D12.

A(n)dependent cell is one whose value depends on the values of other cells in the workbook._________________________

The _______ function calculates the amount paid into an investment or loan during each payment period.

The major advantage of the payback period is that it takes into account the time value of money.

The _______ function takes only these arguments: cost,salvage,and life.

Identify the letter of the choice that best matches the phrase or definition. -Calculates a loan's future value

Case 9-2 Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a straight-line depreciation?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment applied to the principal

The _______ function calculates the present value of an investment or loan.

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

Identify the letter of the choice that best matches the phrase or definition. -Calculates the number of payments required to pay off a loan or reach an investment goal

To project a trend that decreases rather than increases,use a step value of less than _______ for a linear trend.

Seymour tells Charles to search all of the error values until he reaches one that lacks something,and that is the source of the error values in the dependent cells.What does that error value lack?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the payment in each period required to pay off a loan or reach an investment goal

Most Excel financial functions require a particular _______ to the cash flow to return the correct value.

Financial functions format calculated values as currency,with _______.

Case 9-2 Skylar is studying for her midterm exam in her accounting class.Her study partner Lisa is her go-to person for help with calculating depreciation. -Which of the following functions does Lisa say is used to calculate a declining balance depreciation?

Identify the letter of the choice that best matches the phrase or definition. -Calculates the per period interest rate required to pay off a loan or reach an investment goal

To _______ a series,the cells between the first and last cells in the series must be blank.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters