Exam 5: Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Which of the following is the path to the Financial button and the PMT function?

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

Which of the following is the maximum number of active data tables per worksheet?

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

Critical Thinking Questions Case 4-1 Bill has a bicycle repair shop in his basement. He would like a larger workshop so he investigates taking out a loan to convert his garage to a workshop. He uses Excel to create an amortization schedule. After Bill creates the amortization schedule, he decides to add a calculator section to the worksheet. How would he create a column border to separate the calculator from the amortization schedule section?

Discuss the reasons and the two-step process for protecting a worksheet.

A(n) ____________________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.

You can use ____________________ to separate sections of a worksheet.

In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

Modified Multiple Choice An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

____ ensures that users do not change values inadvertently that are critical to the worksheet.

Define a data table and explain the difference between a one-input data table and a two-input data table.

Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.

To control the color and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.