Exam 9: Working With Financial Tools and Functions

Explore all topics

Case-Based Critical Thinking Questions Case 9-1 Christian 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,Sebastian,for tips in how to trace errors in the sheet. -Sebastian tells Christian 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

(43)

Question 141

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

(Multiple Choice)

4.9/5

(49)

Question 142

Tracer arrows disappear when you ____.

(Multiple Choice)

4.8/5

(33)

Question 143

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

(Short Answer)

4.9/5

(33)

Question 144

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

(Multiple Choice)

4.8/5

(40)

Question 145

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

(35)

Question 146

To calculate a declining balance depreciation,use the DVB function.

(True/False)

4.9/5

(43)

Question 147

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

(Multiple Choice)

4.8/5

(36)

Question 148

If you don't include an fv value,Excel assumes a future value of 1._________________________

(True/False)

4.8/5

(29)

Question 149

The ____ function calculates the amount paid into an investment or loan during each payment period.

(Multiple Choice)

4.9/5

(45)

Question 150

Showing 141 - 150 of 150

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

Tracer arrows disappear when you ____.

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

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

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.

To calculate a declining balance depreciation,use the DVB function.

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

If you don't include an fv value,Excel assumes a future value of 1._________________________

The ____ function calculates the amount paid into an investment or loan during each payment period.

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