Exam 6: Managing Multiple Worksheets and Workbooks

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

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

-Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to jump to a specific cell or range within ____.

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

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

In the Edit Links dialog box,the ____ option shows whether Excel successfully accessed the link and updated the values from the source document.

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

When the destination file is closed,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar._________________________

-Click the button marked ____ in the accompanying figure to fix broken links.

Web apps allow you to create,view,and edit Office files directly from a Web browser as well as share files and collaborate with other users online._________________________

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

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

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

If the destination file is closed when you make a change in the source file,you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

In the Edit Links dialog box in the accompanying figure,____ indicates that links are updated automatically.

Case-Based Critical Thinking Questions Case 6-3 Your friend Connor asks you to help him learn more about using hyperlinks in an Excel workbook file. -Which of the following statements about hyperlinks in Excel workbooks is NOT correct?

When two files are linked together,the ____________________ file receives the information.

Case-Based Critical Thinking Questions Case 6-1 Perry is having trouble using linked workbooks,so he consults his colleague Malia for help. -Perry tells Malia that when he attempts to open a workbook,the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Malia suggests several possible causes of this error message.Which of the following is NOT one of the possible causes?

A(n)____________________ is an Excel file that saves information about all of the currently opened workbooks.

____________________ provide additional information about the target of a link.