Question 1

The FV function calculates the full value of an investment or loan._________________________

Accepted Answer

A) True 
 B)False

Question 2

After you select a cell with an error indicator,you can click the Error Checking _______ to display additional information about the possible error and determine if further action is needed.

Accepted Answer

A)  button 
B)  icon 
C)  ScreenTip 
D)  menu 
A)  button 
B)  icon 
C)  ScreenTip 
D)  menu

Question 3

To calculate a series of values from a starting point without a defined ending point,you have to _______ the values.

Accepted Answer

A)  interpolate 
B)  extrapolate 
C)  assess 
D)  plot 
A)  interpolate 
B)  extrapolate 
C)  assess 
D)  plot

Question 4

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 18._________________________

Accepted Answer

A) True 
 B)False

Question 5

When using the PMT function to calculate monthly loan payments,the interest rate and the number of payments should be based on the interest rate per year and the total months to pay off the loan._________________________

Accepted Answer

A) True 
 B)False

Question 6

Which of the following shows the syntax of the NPER function?

Accepted Answer

A)  =NPER(pmt, pv, [fv=0], [type=0]) 
B)  =NPER(rate, pmt, [fv=0], [type=0]) 
C)  =NPER(rate, pmt, pv [, fv=0] [, type=0]) 
D)  =NPER(pmt, rate, pv, [fv=0], [type=0]) 
A)  =NPER(pmt, pv, [fv=0], [type=0]) 
B)  =NPER(rate, pmt, [fv=0], [type=0]) 
C)  =NPER(rate, pmt, pv [, fv=0] [, type=0]) 
D)  =NPER(pmt, rate, pv, [fv=0], [type=0])

Question 7

In the function =CUMIPMT(rate,nper,pv,start,end,type),it is _______ that defines whether the payments are made at the beginning or end of each period.

Accepted Answer

A)  rate 
B)  nper 
C)  end 
D)  type 
A)  rate 
B)  nper 
C)  end 
D)  type

Question 8

To calculate a declining balance depreciation,use the DVB function.

Accepted Answer

A) True 
 B)False

Question 9

The point at which the net present value of an investment equals _______ is the internal rate of return.

Accepted Answer

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

Question 10

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 sum-of-years' digit depreciation?

Accepted Answer

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

Question 11

Identify the letter of the choice that best matches the phrase or definition.
-An interest rate that compares the value of current dollars to future dollars from a series of 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

Question 12

When you borrow money,the money you receive represents a _______ cash flow.

Accepted Answer

A)  positive 
B)  negative 
C)  fixed 
D)  neutral 
A)  positive 
B)  negative 
C)  fixed 
D)  neutral

Question 13

If Charles sees which of the following,Seymour explains,there is a mistyped function name in the sheet.

Accepted Answer

A)  #FNCT? 
B)  #FORM? 
C)  #NAME? 
D)  ##### 
A)  #FNCT? 
B)  #FORM? 
C)  #NAME? 
D)  #####

Question 14

To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.

Accepted Answer

A)  add 
B)  subtract 
C)  multiply 
D)  divide 
A)  add 
B)  subtract 
C)  multiply 
D)  divide

Question 15

The list of values in the XNPV function must include at least one positive cash flow and one negative cash flow.

Accepted Answer

A) True 
 B)False

Question 16

When you extrapolate a series,the _______ value represents the amount that each value is increased or multiplied as the series is extended.

Accepted Answer

A)  Increase 
B)  Step 
C)  Extension 
D)  Advance 
A)  Increase 
B)  Step 
C)  Extension 
D)  Advance

Question 17

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

Accepted Answer

​The financial definition of net prese

Question 18

Describe the steps to interpolate a series of values between starting and ending values.

Accepted Answer

Select the range with the first cell c

Question 19

To calculate the number of montly payments required to pay off a loan or meet an investment goal,use the _______ function.

Accepted Answer

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

Question 20

Use the XNPV and XIRR functions for cash flows that appear _______.

Accepted Answer

A)  with a regular pattern 
B)  at unevenly spaced intervals 
C)  at evenly spaced intervals 
D)  to be cyclical 
A)  with a regular pattern 
B)  at unevenly spaced intervals 
C)  at evenly spaced intervals 
D)  to be cyclical

The FV function calculates the full value of an investment or loan._________________________

After you select a cell with an error indicator,you can click the Error Checking _______ to display additional information about the possible error and determine if further action is needed.

To calculate a series of values from a starting point without a defined ending point,you have to _______ the values.

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 18._________________________

When using the PMT function to calculate monthly loan payments,the interest rate and the number of payments should be based on the interest rate per year and the total months to pay off the loan._________________________

Which of the following shows the syntax of the NPER function?

In the function =CUMIPMT(rate,nper,pv,start,end,type),it is _______ that defines whether the payments are made at the beginning or end of each period.

To calculate a declining balance depreciation,use the DVB function.

The point at which the net present value of an investment equals _______ is the internal rate of return.

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 sum-of-years' digit depreciation?

Identify the letter of the choice that best matches the phrase or definition. -An interest rate that compares the value of current dollars to future dollars from a series of cash flows

When you borrow money,the money you receive represents a _______ cash flow.

If Charles sees which of the following,Seymour explains,there is a mistyped function name in the sheet.

To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.

The list of values in the XNPV function must include at least one positive cash flow and one negative cash flow.

When you extrapolate a series,the _______ value represents the amount that each value is increased or multiplied as the series is extended.

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

Describe the steps to interpolate a series of values between starting and ending values.

To calculate the number of montly payments required to pay off a loan or meet an investment goal,use the _______ function.

Use the XNPV and XIRR functions for cash flows that appear _______.

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 FV function calculates the full value of an investment or loan._________________________

After you select a cell with an error indicator,you can click the Error Checking _______ to display additional information about the possible error and determine if further action is needed.

To calculate a series of values from a starting point without a defined ending point,you have to _______ the values.

If you plan to invest money for 18 months,the value of the nper argument in the PMT function is 18._________________________

When using the PMT function to calculate monthly loan payments,the interest rate and the number of payments should be based on the interest rate per year and the total months to pay off the loan._________________________

Which of the following shows the syntax of the NPER function?

In the function =CUMIPMT(rate,nper,pv,start,end,type),it is _______ that defines whether the payments are made at the beginning or end of each period.

To calculate a declining balance depreciation,use the DVB function.

The point at which the net present value of an investment equals _______ is the internal rate of return.

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 sum-of-years' digit depreciation?

Identify the letter of the choice that best matches the phrase or definition. -An interest rate that compares the value of current dollars to future dollars from a series of cash flows

When you borrow money,the money you receive represents a _______ cash flow.

If Charles sees which of the following,Seymour explains,there is a mistyped function name in the sheet.

To calculate the annual rate,you must _______ the value returned by the RATE function by the number of payments per year.

The list of values in the XNPV function must include at least one positive cash flow and one negative cash flow.

When you extrapolate a series,the _______ value represents the amount that each value is increased or multiplied as the series is extended.

Does the NPV function in Excel correspond to the financial definition of net present value? Explain your answer.

Describe the steps to interpolate a series of values between starting and ending values.

To calculate the number of montly payments required to pay off a loan or meet an investment goal,use the _______ function.

Use the XNPV and XIRR functions for cash flows that appear _______.

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