Exam 6: Excel 2: Managing Multiple Worksheets and Workbooks

To delete a hyperlink, right-click the hyperlink cell and then click Clear Value . _________________________

A ____ is a workbook that you can open with the text, formats, and formulas already built into it.

Hyperlinks are usually represented by words with colored letters and underlines or images. _________________________

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

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

The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

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

Formulas created using the point-and-click method contain ____ references.

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget, Inventory List, and Time sheets. _________________________

To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.

The ____ template in Excel creates an online time card to track employees' work hours.

A(n)____________________ group is a collection of two or more selected worksheets.

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