Question 1

To calculate the number of quarterly payments required to pay off a loan,use the _______ function.

Accepted Answer

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

Question 2

At higher rates of return,the net present value of the investment goes up._________________________

Accepted Answer

A) True 
 B)False  False

Question 3

The DB function used to calculate the declining balance depreciation has the following syntax: _______.

Accepted Answer

A)  =DB(salvage, life, period [month]) 
B)  =DB(cost, salvage, period [month]) 
C)  =DB(salvage, cost, life, period [month]) 
D)  =DB(cost, salvage, life, period [month]) 
A)  =DB(salvage, life, period [month]) 
B)  =DB(cost, salvage, period [month]) 
C)  =DB(salvage, cost, life, period [month]) 
D)  =DB(cost, salvage, life, period [month]) D

Question 4

You can extrapolate a series of values from the Series dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 5

The function DDB is used to calculate a(n)declining balance depreciation._________________________

Accepted Answer

A) True 
 B)False

Question 6

If the NPER function returns #NUM!,the loan cannot be repaid in any length of time.

Accepted Answer

A) True 
 B)False

Question 7

Cash flow is concerned with the direction of money as it moves in and out of a company.

Accepted Answer

A) True 
 B)False

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-Return rate for a series of future cash flows that will result in a net present value of zero

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 9

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 depreciation if it is variable?

Accepted Answer

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

Question 10

A(n)negative cash flow occurs when cash is going away from the investor._________________________

Accepted Answer

A) True 
 B)False

Question 11

In a(n)_______ trend,the values change by a constant amount.

Accepted Answer

A)  linear 
B)  growth 
C)  periodic 
D)  orthogonal 
A)  linear 
B)  growth 
C)  periodic 
D)  orthogonal

Question 12

To evaluate a formula,you select the cell and then click the _______ button from the Formula Auditing group on the Formulas tab.

Accepted Answer

A)  Define Formula 
B)  Select Formula 
C)  Check Function 
D)  Evaluate Formula 
A)  Define Formula 
B)  Select Formula 
C)  Check Function 
D)  Evaluate Formula

Question 13

The fv argument is required in the PMT function.

Accepted Answer

A) True 
 B)False

Question 14

With the PMT function,the type argument is _______ when the payments are made at the end of each period.

Accepted Answer

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

Question 15

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.

Accepted Answer

A)  PMT 
B)  IPMT 
C)  INPMT 
D)  NPMT 
A)  PMT 
B)  IPMT 
C)  INPMT 
D)  NPMT

Question 16

The _______ function returns the sum-of-years' digit depreciation that results in a more accelerated depreciation than straight-line depreciation but less than declining balance depreciation.

Accepted Answer

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

Question 17

If you don't include a pv value,Excel assumes a future value of 1._________________________

Accepted Answer

A) True 
 B)False

Question 18

The process of allocating the original cost of an investment over the years of use is known as _______.

Accepted Answer

A)  interest 
B)  balance 
C)  depreciation 
D)  amortization 
A)  interest 
B)  balance 
C)  depreciation 
D)  amortization

Question 19

In an amortization schedule,use relative references to refer to the original loan conditions and use absolute references to refer to information about specific payment periods.

Accepted Answer

A) True 
 B)False

Question 20

Identify the letter of the choice that best matches the phrase or definition.
-Calculates the present value of a series of future cash flows

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

To calculate the number of quarterly payments required to pay off a loan,use the _______ function.

At higher rates of return,the net present value of the investment goes up._________________________

The DB function used to calculate the declining balance depreciation has the following syntax: _______.

You can extrapolate a series of values from the Series dialog box._________________________

The function DDB is used to calculate a(n)declining balance depreciation._________________________

If the NPER function returns #NUM!,the loan cannot be repaid in any length of time.

Cash flow is concerned with the direction of money as it moves in and out of a company.

Identify the letter of the choice that best matches the phrase or definition. -Return rate for a series of future cash flows that will result in a net present value of zero

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 depreciation if it is variable?

A(n)negative cash flow occurs when cash is going away from the investor._________________________

In a(n)_______ trend,the values change by a constant amount.

To evaluate a formula,you select the cell and then click the _______ button from the Formula Auditing group on the Formulas tab.

The fv argument is required in the PMT function.

With the PMT function,the type argument is _______ when the payments are made at the end of each period.

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.

The _______ function returns the sum-of-years' digit depreciation that results in a more accelerated depreciation than straight-line depreciation but less than declining balance depreciation.

If you don't include a pv value,Excel assumes a future value of 1._________________________

The process of allocating the original cost of an investment over the years of use is known as _______.

In an amortization schedule,use relative references to refer to the original loan conditions and use absolute references to refer to information about specific payment periods.

Identify the letter of the choice that best matches the phrase or definition. -Calculates the present value of a series of future cash flows

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

To calculate the number of quarterly payments required to pay off a loan,use the _______ function.

At higher rates of return,the net present value of the investment goes up._________________________

The DB function used to calculate the declining balance depreciation has the following syntax: _______.

You can extrapolate a series of values from the Series dialog box._________________________

The function DDB is used to calculate a(n)declining balance depreciation._________________________

If the NPER function returns #NUM!,the loan cannot be repaid in any length of time.

Cash flow is concerned with the direction of money as it moves in and out of a company.

Identify the letter of the choice that best matches the phrase or definition. -Return rate for a series of future cash flows that will result in a net present value of zero

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 depreciation if it is variable?

A(n)negative cash flow occurs when cash is going away from the investor._________________________

In a(n)_______ trend,the values change by a constant amount.

To evaluate a formula,you select the cell and then click the _______ button from the Formula Auditing group on the Formulas tab.

The fv argument is required in the PMT function.

With the PMT function,the type argument is _______ when the payments are made at the end of each period.

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.

The _______ function returns the sum-of-years' digit depreciation that results in a more accelerated depreciation than straight-line depreciation but less than declining balance depreciation.

If you don't include a pv value,Excel assumes a future value of 1._________________________

The process of allocating the original cost of an investment over the years of use is known as _______.

In an amortization schedule,use relative references to refer to the original loan conditions and use absolute references to refer to information about specific payment periods.

Identify the letter of the choice that best matches the phrase or definition. -Calculates the present value of a series of future cash flows

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