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

Smart worksheet design starts with visualizing the results you need.

Critical Thinking Questions Case 4-2 Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. Ruth has fully tested all of the formulas in her worksheet and the correct results appear. Ruth provides a copy of the worksheet file to Barret so he can use it for his business calculations. As a user, Barret can make changes only to certain cells. What did Ruth do to ensure the other cells cannot be altered by user Barret?

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

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

A cell name often is created from column and row titles.

To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

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.

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.

To hide an entire workbook on an unattended computer, click the Hide button on the ____.

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.

What is the path to the What-If Analysis button?