Exam 6: Excell: Managing Multiple Worksheets and Workbooks

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

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

To manually ____________________ a link and see the new data values, click the Update Values button.

To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____.

When the source and destination workbooks are stored in the same folder, you still need to include the location information in the workbook reference that links the two files.

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

If you want to create a cell reference to B6 on the Summary Info worksheet of the Sales.xls workbook, you would use the following external reference: ____.

The general format of a 3-D cell reference is ____.

A(n) template is a workbook with labels, formats, and formulas already built into it with data removed.

If both the ____________________ and source files are open, Excel will update the link between them automatically whenever a value in the source file is changed.

The ____ arrangement option layers the open workbooks on the screen.

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

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

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

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

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

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