Exam 6: Excell: Working With Multiple Worksheets and Workbooks

If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.

Before printing a workbook, consider the ____________________ , which defines the appearance and format of a printed worksheet.

You can drill all of the following down through a workbook EXCEPT ____.

You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.

The ____ keyboard shortcut copies an image of the source area as a picture.

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

To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.

You can display the ____ tab to specify page setup options.

If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.

Single quotation marks surrounding the ____ are required if any of the names in a 3-D reference contain spaces.

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

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

You can use the ENTER key to complete a paste operation.

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. Judy sends you another e-mail thanking you for your tip and asks if there is any quick way that she can copy the format of a given source area but not its contents. You tell Judy to use the ____ keyboard shortcut.

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

When you insert a manual page break, Excel displays a(n) ____ line between pages.

When should you use the ROUND function?