Exam 9: Exploring Financial Tools and Functions

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

(Multiple Choice)

4.8/5

(75)

Question 61

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

(True/False)

4.9/5

(75)

Question 62

The tracer arrow provides a visual clue to the source of the error.

(True/False)

4.8/5

(69)

Question 63

A(n)_______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.

(Multiple Choice)

4.9/5

(70)

Question 64

Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment used to pay off the interest

(Multiple Choice)

4.8/5

(78)

Question 65

If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?

(Multiple Choice)

4.7/5

(81)

Question 66

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 double-declining balance depreciation?

(Multiple Choice)

4.7/5

(70)

Question 67

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.

(Multiple Choice)

4.9/5

(71)

Question 68

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

(Multiple Choice)

4.8/5

(67)

Question 69

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

(Multiple Choice)

4.8/5

(95)

Question 70

Seymour tells Charles that all error values begin with the same symbol,so they can be easily identified as errors.What is the symbol?

(Multiple Choice)

4.8/5

(81)

Question 71

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

(Essay)

4.9/5

(78)

Question 72

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the chance._________________________

(True/False)

4.9/5

(76)

Question 73

To calculate the internal rate of return,use the _______ function with the cost of the initial investment as the first cash flow value in a series.

(Multiple Choice)

4.8/5

(84)

Question 74

If Charles sees red tracer arrows that means there is an error in the value being received from the precedent cell or passed to the _______ cell.

(Multiple Choice)

4.9/5

(89)

Question 75

Showing 61 - 75 of 75

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

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

The tracer arrow provides a visual clue to the source of the error.

A(n)_______ arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.

Identify the letter of the choice that best matches the phrase or definition. -Calculates the amount of a loan payment used to pay off the interest

If in Charles's sheet,cell A4 is a precedent cell for cell B7,what kind of a cell is B7?

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 double-declining balance depreciation?

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.

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

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

Seymour tells Charles that all error values begin with the same symbol,so they can be easily identified as errors.What is the symbol?

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

The possibility that the entire transaction will fail,resulting in a loss of the initial investment is called the chance._________________________

To calculate the internal rate of return,use the _______ function with the cost of the initial investment as the first cash flow value in a series.

If Charles sees red tracer arrows that means there is an error in the value being received from the precedent cell or passed to the _______ cell.

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