Exam 4: Financial Functions,Data Tables,and Amortization Schedules

Which of the following is the path to the Name Manager button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Speeds up printing when it contains a check mark.

You can define descriptive names that are not column titles or row titles to represent cells,ranges of cells,formulas,or constants._________________________

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.

You should create worksheets as if you are going to use them only once.

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

You should create a(n)____ when you want to keep others from changing the worksheet from protected to unprotected.

In the Varying Interest Rate Schedule created in this chapter,the series of interest rates in column B are called ____________________.

The PMT function has two arguments: rate and payment.

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n)____________________ status.

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

Which of the following are PMT function arguments?

You can name a range by ____.

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?

Periods and underscore characters are allowed in,but cannot begin,cell ____________________.

You should protect cells only after the ____________________ has been tested fully and the correct results appear.

Which of the following is the path to the Protect Sheet button?

In a data table,the ____________________ you are analyzing must include a cell reference to the input cell.

When you format a cell to display percentages,Excel assumes that whatever you enter into that cell in the future will be a percentage.