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

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

To prevent sensitive data from being seen in a worksheet,you can hide the worksheet by clicking ____ on the shortcut menu.

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

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 can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

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

Data tables have one purpose: to organize the answers to what-if questions.​

If you click the ____,Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.

Cell ____ can be used to distinguish the different functional parts of a worksheet.

The print options available on the Margins tab in the

Which of the following are financial functions?

If you enter a formula using Point mode and click a cell that has an assigned name,then Excel will insert the name of the cell rather than the cell reference.

To prevent round-off errors,use the ____ function.

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.

When a cell is formatted for a percent,if you enter the number .5 Excel translates the value as 50%.

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

Which of the following is the path to the Cell Styles button?

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

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.

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