Exam 6: Excell: Working With Multiple Worksheets and Workbooks

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

A workbook contains ____ worksheet(s) by default.

The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.

Critical Thinking Questions Case 5-2 Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data. Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. You tell Judy that ____.

Headers, footers, and margins are all ____ options.

You can press and hold or right-click a sheet tab and then tap or click ____________________ on the shortcut menu to insert a new worksheet.

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Which of the following is a method of electronic document distribution?

When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Which of the following is the path to the Fill button?

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

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

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

You should create good ____ to ensure your workbooks are free of errors.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.

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.

The ____________________ tab contains the commands for setting the location of page breaks or centering a printout horizontally and vertically.

Which of the following is the path to the Insert Cells button?

To copy the contents of a cell to the cell directly below it, click the target cell and press ____.