Question 1

-The item marked 2 in the accompanying figure represents the _______ trend.

Accepted Answer

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

Question 2

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 3

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 4

MATCHING
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

Question 5

The PMT value is also known as the ____________________ payment.

Accepted Answer

The answer of The PMT value is also known as...

Question 6

A(n)____________________ cash flow occurs whenever money is flowing into the account.

Accepted Answer

The answer of A(n)____________________ cash flow occurs whenever money is...

Question 7

When you extrapolate a series,you do not have to specify a(n)____________________ value.

Accepted Answer

stopping
e

Question 8

-As shown in the accompanying figure,when plotted,a(n)_______ trend displays the greatest increases near the end of the series.

Accepted Answer

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

Question 9

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 10

The _______ function calculates the number of payment periods in an investment or loan.

Accepted Answer

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

Question 11

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, Seymour, for tips on how to trace errors in the sheet.
-If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?

Accepted Answer

A) contingent cell 
B) dependent cell 
C) antecedent cell 
D) indicated cell 
A) contingent cell 
B) dependent cell 
C) antecedent cell 
D) indicated cell

Question 12

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 13

The _______ period is a quick method of projecting the value of an investment.

Accepted Answer

A) investment 
B) payback 
C) cumulative 
D) time-value 
A) investment 
B) payback 
C) cumulative 
D) time-value

Question 14

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 15

MATCHING
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 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the internal rate of return for a series of unevenly spaced payments

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 17

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 18

When you change a cell's value,a Watch Window allows you to view the impact of the change on widely scattered dependent cells.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

-The item marked 2 in the accompanying figure represents the _______ trend.

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

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

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

The PMT value is also known as the ____________________ payment.

A(n)____________________ cash flow occurs whenever money is flowing into the account.

When you extrapolate a series,you do not have to specify a(n)____________________ value.

-As shown in the accompanying figure,when plotted,a(n)_______ trend displays the greatest increases near the end of the series.

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

The _______ function calculates the number of payment periods in an investment or loan.

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, Seymour, for tips on how to trace errors in the sheet. -If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?

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

The _______ period is a quick method of projecting the value of an investment.

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

MATCHING 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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the internal rate of return for a series of unevenly spaced payments

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

When you change a cell's value,a Watch Window allows you to view the impact of the change on widely scattered dependent cells.

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

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

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 9: Exploring Financial Tools and Functions

-The item marked 2 in the accompanying figure represents the _______ trend.

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

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

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

The PMT value is also known as the ____________________ payment.

A(n)____________________ cash flow occurs whenever money is flowing into the account.

When you extrapolate a series,you do not have to specify a(n)____________________ value.

-As shown in the accompanying figure,when plotted,a(n)_______ trend displays the greatest increases near the end of the series.

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

The _______ function calculates the number of payment periods in an investment or loan.

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, Seymour, for tips on how to trace errors in the sheet. -If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?

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

The _______ period is a quick method of projecting the value of an investment.

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

MATCHING 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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the internal rate of return for a series of unevenly spaced payments

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

When you change a cell's value,a Watch Window allows you to view the impact of the change on widely scattered dependent cells.

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

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

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters