W5- 11/04

Evelyn wants to work on different parts of a workbook at the same time by displaying worksheets in separate windows. Which option on the View tab should she select?

• Arrange All

• New Window

• Zoom

• Page Break Preview

To create a workbook containing text, formulas, macros, and formatting that you use repeatedly, you create a _____.

• master

• model

• template

• standard

Ricki has an Analysis workbook containing many worksheets of sales data that she wants to use in a new workbook. What is the easiest way for her to use the sales data in the new workbook?

• Copy the cells containing sales data to the new workbook.

• Insert hyperlinks from the Analysis workbook to the new workbook.

• Copy the worksheets from the Analysis workbook to the new workbook.

• Hide the worksheets in the Analysis workbook.

Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

• Create a custom view of the worksheets.

• Group the worksheets.

• View the worksheets side by side.

• Link the worksheets.

A _____ is text or an image you click to open a webpage or file.

• 3-D reference

• Hyperlink

• ScreenTip

• Template

Which of the following techniques can you use to remove hyperlink from a cell?

• Click the Clear button on the Home tab and then click Remove Hyperlink.

• Click the Clear button on the Home tab and then click Remove Hyperlink.

• Right-click the hyperlink and then click Restore on the shortcut menu.

• Right-click the hyperlink and then click Remove Hyperlink on the shortcut menu.

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

• Add a description.

• Add a ScreenTip.

• Change the Link to location.

• Add a HyperTip.

How do you select a cell containing a hyperlink without activating the link?

• Double-click the cell.

• Right-click the cell.

• Click the cell and then click Do Not Activate.

• Click the cell and then click Edit Hyperlink.

What happens when you click a link to a Word document while working in Excel?

• Excel displays the Word document within Excel.

• Excel closes, and then Word starts so you can navigate to the document.

• Word starts and opens the linked document.

• Your default browser opens and displays the Word document.

A workbook template has which of the following file extensions?

• .xltx

• .xls

• .xlsx

• .xlst