Question 1

At higher rates of return,the net present value of the investment goes $\underline { \text { up. } }$________________________

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 to search all of the error values until he reaches one that lacks something,and that is the source of the error values in the dependent cells.What does that error value lack?

Accepted Answer

A) contingencies 
B) dependencies 
C) antecedents 
D) precedents 
A) contingencies 
B) dependencies 
C) antecedents 
D) precedents

Question 4

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

Accepted Answer

The answer depends on the type of asset

Question 5

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

Accepted Answer

A) Asset Report 
B) Income Statement 
C) Balance Sheet 
D) Transactions 
A) Asset Report 
B) Income Statement 
C) Balance Sheet 
D) Transactions

Question 6

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 7

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 8

If you know the beginning and ending values in a series and the series trend,you can fill in the missing values through ____________________.

Accepted Answer

The answer of If you know the beginning and ending...

Question 9

You can extrapolate a series of values from the $\underline { \text { Series }   }$dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 10

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

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 12

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

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

Question 14

A(n)____________________ is also known as a profit and loss statement.

Accepted Answer

The answer of A(n)____________________ is also known as a profit...

Question 15

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

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

Accepted Answer

The answer of The financial definition of ____________________ is the...

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Calculates the number of payments required to pay off a loan or reach an investment goal

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 18

The major advantage of the payback period is that it takes into account the time value of money.

Accepted Answer

A) True 
 B)False

Question 19

If you don't include a pv value,Excel assumes a future value of $\underline {  1 .  }$_________________________

Accepted Answer

A) True 
 B)False

Question 20

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

At higher rates of return,the net present value of the investment goes $\underline { \text { up. } }$ ________________________

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

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

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

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

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

If you know the beginning and ending values in a series and the series trend,you can fill in the missing values through ____________________.

You can extrapolate a series of values from the $\underline { \text { Series } }$ dialog box._________________________

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?

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

MATCHING 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

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

A(n)____________________ is also known as a profit and loss statement.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the number of payments required to pay off a loan or reach an investment goal

The major advantage of the payback period is that it takes into account the time value of money.

If you don't include a pv value,Excel assumes a future value of $\underline { 1 . }$ _________________________

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.

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

At higher rates of return,the net present value of the investment goes up. ‾\underline { \text { up. } } up. ​ ________________________

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

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

A(n)_______ worksheet projects the company's expected assets,liabilities,and equity.

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

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

If you know the beginning and ending values in a series and the series trend,you can fill in the missing values through ____________________.

You can extrapolate a series of values from the Series ‾\underline { \text { Series } } Series ​ dialog box._________________________

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?

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

MATCHING 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

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

A(n)____________________ is also known as a profit and loss statement.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Calculates the number of payments required to pay off a loan or reach an investment goal

The major advantage of the payback period is that it takes into account the time value of money.

If you don't include a pv value,Excel assumes a future value of 1.‾\underline { 1 . }1.​ _________________________

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.

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

At higher rates of return,the net present value of the investment goes $\underline { \text { up. } }$ ________________________

You can extrapolate a series of values from the $\underline { \text { Series } }$ dialog box._________________________

If you don't include a pv value,Excel assumes a future value of $\underline { 1 . }$ _________________________