Exam 6: Managing Multiple Worksheets and Workbooks

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

What is an example of when you would use a template? Name at least three benefits of using a workbook template.

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? 

____________________ appear whenever you place the pointer over a hyperlink.

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

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.

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

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

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

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. -Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible.Ryder opens all of the workbooks,and then he clicks the View tab on the Ribbon and clicks the Arrange All button.What should he do next to obtain the desired layout? 

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

If a worksheet group includes all the worksheets in a workbook,you can edit only the active worksheet.

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

If Excel successfully accessed the link and updated the values from the source document,the status in the Edit Links dialog box will be ____.

Using multiple worksheets makes it easier to group and summarize data.Describe features that can be applied by forming a worksheet group.

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

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

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

If you delete a value from one cell in a worksheet group,the content is also deleted from the same cell in all the worksheets in the group.