Exam 6: Excel: Managing Multiple Worksheets and Workbooks

To select nonadjacent worksheets you use the ____ key.

Using multiple worksheets makes it more difficult for you to group your data.

When you reference cells and ranges in other worksheets if the worksheet name contains spaces you must enclose the sheet name in ____.

Click the button marked ____ in the accompanying figure to find out whether Excel has attempted to update the links in this session.

To create a template you simply save an Excel workbook in template format using the ____ dialog command.

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.

To select nonadjacent worksheets you click a sheet tab of one of the worksheets and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group.

Which of the following is NOT an option for arranging your workbooks?

When you reference a cell or range in a different worksheet the ____ separates the sheet reference from the cell reference.

By default hyperlinks like those created by the dialog box in the accompanying figure are in ____ font.

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

The default template has ____ worksheets inserted in the workbook.

When you click a(n)____ the computer switches to the file or portion of the file that it references.

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Click the item marked ____ to set the text that will appear whenever you place the pointer over a hyperlink.

A(n)____________________ is a link in a file such as a workbook to information within that file or another file.

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.