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

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

You use a(n) ____ to automate data analyses.

A column border is an unused column with a significantly reduced width.

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. Bill would like to borrow $50,000 and pay it off in 10 years. What components will he need to identify for a loan amortization schedule created on an Excel worksheet?

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

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

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

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

You should ____________________ all other cells (non data entry) in a worksheet from input by the user of the worksheet.

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

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

Modified Multiple Choice You can name a range by ____.

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.

In general, all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.

A cell ____ often is created from column or row titles.

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

With a(n) ____ data table you can vary the value in one cell.

The arguments in ____ in the ScreenTip for a function are optional.

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