Question 1

If you are making periodic monthly payments,and the interest is compounded monthly,then the number of periods is in years.

Accepted Answer

A) True 
 B)False  False

Question 2

The financial definition of net present value is the difference between the present value of future cash flows and the current cost of the initial investment.

Accepted Answer

A) True 
 B)False  True

Question 3

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 B

Question 4

-As shown in the accompanying figure,earlier payment periods apply more of the payment toward the principal.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

The PMT value is also known as the ____ payment.

Accepted Answer

A)  periodic 
B)  placement 
C)  inflow 
D)  indexed 
A)  periodic 
B)  placement 
C)  inflow 
D)  indexed

Question 7

-The item marked 2 in the accompanying figure is the ____ value.

Accepted Answer

A)  sum 
B)  declining balance 
C)  initial asset 
D)  salvage 
A)  sum 
B)  declining balance 
C)  initial asset 
D)  salvage

Question 8

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 month and the total ____ to pay off the loan.

Accepted Answer

A)  weeks 
B)  months 
C)  years 
D)  any of the above 
A)  weeks 
B)  months 
C)  years 
D)  any of the above

Question 9

As shown in the accompanying figure,in a(n)____ trend,the values do not change by a constant amount.

Accepted Answer

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

Question 10

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 11

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

Accepted Answer

Select the range with the first cell con

Question 12

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 13

The ____________________ is the amount of the loan that is still unpaid.

Accepted Answer

The answer of The ____________________ is the amount of the...

Question 14

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 15

____ depreciation depreciates an asset by a constant percentage each year rather than a constant amount.

Accepted Answer

A)  Declining balance 
B)  Double declining 
C)  Interest reduced 
D)  Straight-line 
A)  Declining balance 
B)  Double declining 
C)  Interest reduced 
D)  Straight-line

Question 16

The ____________________ argument specifies whether payments are made at the end of each period or at the beginning.

Accepted Answer

The answer of The ____________________ argument specifies whether payments are...

Question 17

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

Accepted Answer

A)  monthly 
B)  daily 
C)  quarterly 
D)  either a.or c. 
A)  monthly 
B)  daily 
C)  quarterly 
D)  either a.or c.

Question 18

If the NPER function returns the error value ____,the loan cannot be paid back in any length of time.

Accepted Answer

A)  #REF! 
B)  #NUM! 
C)  #TIME! 
D)  #PER! 
A)  #REF! 
B)  #NUM! 
C)  #TIME! 
D)  #PER!

Question 19

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)  asses 
D)  plot 
A)  interpolate 
B)  extrapolate 
C)  asses 
D)  plot

Question 20

How do you determine which method of depreciation is most appropriate?

Accepted Answer

The answer depends on the type of asset

If you are making periodic monthly payments,and the interest is compounded monthly,then the number of periods is in years.

The financial definition of net present value is the difference between the present value of future cash flows and the current cost of the initial investment.

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

-As shown in the accompanying figure,earlier payment periods apply more of the payment toward the principal.

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

The PMT value is also known as the ____ payment.

-The item marked 2 in the accompanying figure is the ____ value.

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 month and the total ____ to pay off the loan.

As shown in the accompanying figure,in a(n)____ trend,the values do not change by a constant amount.

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

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

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

The ____________________ is the amount of the loan that is still unpaid.

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

____ depreciation depreciates an asset by a constant percentage each year rather than a constant amount.

The ____________________ argument specifies whether payments are made at the end of each period or at the beginning.

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

If the NPER function returns the error value ____,the loan cannot be paid back in any length of time.

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

How do you determine which method of depreciation is most appropriate?

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 9: Working With Financial Tools and Functions

If you are making periodic monthly payments,and the interest is compounded monthly,then the number of periods is in years.

The financial definition of net present value is the difference between the present value of future cash flows and the current cost of the initial investment.

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

-As shown in the accompanying figure,earlier payment periods apply more of the payment toward the principal.

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

The PMT value is also known as the ____ payment.

-The item marked 2 in the accompanying figure is the ____ value.

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 month and the total ____ to pay off the loan.

As shown in the accompanying figure,in a(n)____ trend,the values do not change by a constant amount.

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

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

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

The ____________________ is the amount of the loan that is still unpaid.

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

____ depreciation depreciates an asset by a constant percentage each year rather than a constant amount.

The ____________________ argument specifies whether payments are made at the end of each period or at the beginning.

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

If the NPER function returns the error value ____,the loan cannot be paid back in any length of time.

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

How do you determine which method of depreciation is most appropriate?

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters