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

-The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

To select nonadjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tabs of the remaining sheets you want to select.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A formula that depends on its own value.

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.

When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A workbook that automatically reads data from linked workbooks.

To reference cells in other sheets in a workbook when creating a formula, include the worksheet name rather than the cell reference.

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

A(n) ____ reference is a formula that depends on its own value.