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

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

Similar to the spell checker,Excel has a formula checker that checks formulas in a worksheet for rule ____.

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

Excel lets you format ____________________ before you enter data,when you enter data,incrementally after entering sections of data,and after you enter all the data.

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

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

You can delete a data table by selecting the data table and then ____.

Spreadsheet specialists usually format a worksheet before they enter any data.

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

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

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

You can use ____________________ to separate sections of a worksheet.

Once you set a print area,Excel will continue to print the specified range,rather than the entire worksheet.

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

Data tables must be built in a(n)____ area of a worksheet.

Data tables have multiple purpose(s)._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Showing only the parts of a worksheet that the user needs to see.

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

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

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.