Question 1

-The item marked 1 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

A(n)$\underline {\text { dependent }}$ cell is one whose value depends on the values of other cells in the workbook._________________________

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

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 6

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 $\underline {\text { year }}$ and the total months to pay off the loan._________________________

Accepted Answer

A) True 
 B)False

Question 7

A red tracer arrow indicates that an error has been received from the ____________________ cell or passed to the dependent cell.

Accepted Answer

The answer of A red tracer arrow indicates that an...

Question 8

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 9

The fv argument is required in the PMT function.

Accepted Answer

A) True 
 B)False

Question 10

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the $\underline {   \text { chance } }$._________________________

Accepted Answer

A) True 
 B)False

Question 11

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 present

Question 12

-The item marked 1 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 13

The function DDB is used to calculate a(n)$\underline { \text { declining } }$ balance depreciation._________________________

Accepted Answer

A) True 
 B)False

Question 14

A(n)____________________ provides details about each loan payment,specifying how much of the payment is devoted toward interest and how much toward repaying the principal.

Accepted Answer

amortizati

Question 15

The NPV function is used in calculating the net present value of a transaction,which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.

Accepted Answer

A) current 
B) projected 
C) future 
D) total 
A) current 
B) projected 
C) future 
D) total

Question 16

With ____________________ the asset loses value by equal amounts each year until it reaches the salvage value at the end of its useful life.

Accepted Answer

straight-l

Question 17

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.
-Seymour tells Charles that all error values begin with the same symbol,so they can be easily identified as errors.What is the symbol?

Accepted Answer

A) # 
B) & 
C) ^ 
D) % 
A) # 
B) & 
C) ^ 
D) %

Question 18

-As shown in the accompanying figure,a(n)_______ trend appears as a straight line.

Accepted Answer

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

Question 19

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 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 20

MATCHING
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

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

A(n) $\underline {\text { dependent }}$ cell is one whose value depends on the values of other cells in the workbook._________________________

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

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

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

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 $\underline {\text { year }}$ and the total months to pay off the loan._________________________

A red tracer arrow indicates that an error has been received from the ____________________ cell or passed to the dependent cell.

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

The fv argument is required in the PMT function.

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the $\underline { \text { chance } }$ ._________________________

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

-The item marked 1 in the accompanying figure is the _______ value.

The function DDB is used to calculate a(n) $\underline { \text { declining } }$ balance depreciation._________________________

A(n)____________________ provides details about each loan payment,specifying how much of the payment is devoted toward interest and how much toward repaying the principal.

The NPV function is used in calculating the net present value of a transaction,which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.

With ____________________ the asset loses value by equal amounts each year until it reaches the salvage value at the end of its useful life.

-As shown in the accompanying figure,a(n)_______ trend appears as a straight line.

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

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 1 in the accompanying figure represents the _______ trend.

A(n) dependent ‾\underline {\text { dependent }} dependent ​ cell is one whose value depends on the values of other cells in the workbook._________________________

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

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

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

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 ‾\underline {\text { year }} year ​ and the total months to pay off the loan._________________________

A red tracer arrow indicates that an error has been received from the ____________________ cell or passed to the dependent cell.

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

The fv argument is required in the PMT function.

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the chance ‾\underline { \text { chance } } chance ​ ._________________________

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

-The item marked 1 in the accompanying figure is the _______ value.

The function DDB is used to calculate a(n) declining ‾\underline { \text { declining } } declining ​ balance depreciation._________________________

A(n)____________________ provides details about each loan payment,specifying how much of the payment is devoted toward interest and how much toward repaying the principal.

The NPV function is used in calculating the net present value of a transaction,which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.

With ____________________ the asset loses value by equal amounts each year until it reaches the salvage value at the end of its useful life.

-As shown in the accompanying figure,a(n)_______ trend appears as a straight line.

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

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

A(n) $\underline {\text { dependent }}$ cell is one whose value depends on the values of other cells in the workbook._________________________

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 $\underline {\text { year }}$ and the total months to pay off the loan._________________________

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the $\underline { \text { chance } }$ ._________________________

The function DDB is used to calculate a(n) $\underline { \text { declining } }$ balance depreciation._________________________