Exam 6: Managing Multiple Worksheets and Workbooks

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

-In the Edit Links dialog box in the accompanying figure,____ in the Update column would indicate that a link has to be updated manually by the user.

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

A 3-D cell ____________________ specifies not only the rows and columns of a cell range,but also the range of worksheet names that the cells appear on.

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to a location in his current workbook.He clicks the Hyperlink button in the Links group on the INSERT tab.What option should he select from the Link to list?

-In the figure above,cell A8 contains a $\underline { \text { hyperlink } }$ ._________________________

Ryder has discovered the power of creating and viewing multiple workbooks. -When Ryder goes to save the workbooks,what is the required file extension?

To select nonadjacent worksheets,you click a sheet tab of one of the worksheets,and then press and hold down the $\underline { \mathrm{Ctrl} }$ key as you click the sheet tabs of other worksheets you want included in the group._________________________

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

When you create a new workbook from a template,an unnamed copy of the template opens.

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. -Simon tells Brooke 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." Brooke suggests several possible causes of this error message.Which of the following is a possible cause?

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

What are the steps to inserting a hyperlink and linking to: a file or Web page,a location in the current workbook,a new document,and an e-mail address.

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. -Finally,Simon asks Brooke what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

A formula can include a reference to another workbook (called an ____ reference),which creates a set of linked workbooks.

A workbook based on a specific template always displays the name of the template followed by the date.

In the Links group,click the Hyperlink button and the _______ Hyperlink dialog box opens.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains text,formats,and formulas already built into it for your use

All template files have the .xlts file extension.