Exam 6: Excel 2: Managing Multiple Worksheets and Workbooks

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. After Brooke has helped Simon to resolve his original problem, Simon asks her about another linked workbook he has received. The source files for this workbook have not been included, but Simon would like to use the workbook with the most recent values from the source files. What should Brooke tell him?

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. Which of the following statements about hyperlinks in Excel workbooks is correct?

____________________ appear whenever you place the pointer over a hyperlink.

The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font.

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

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.

Case-Based Critical Thinking Questions 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?

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.

When you use the point-and-click method to build formulas with external references, Excel enters all of the required punctuation, including quotation marks. _________________________

____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Jared wants to create a hyperlink to link to new a document. What should he click in the Link to list?

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

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

If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

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.

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored. _________________________

When two files are linked together, the workbook that contains the information is the ____________________ file.

The ____ caption indicates a worksheet group.