Exam 6: Managing Multiple Worksheets and Workbooks

The worksheet range ____ references the worksheets,"Sheet1," "Sheet2," "Sheet3," and "Sheet4." 

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

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

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.

Identify the letter of the choice that best matches the phrase or definition. -​A connection between two files allowing information to be transferred from one file to the other

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

In order to reference data located in one workbook in another workbook,you have to create a(n)dialog between the two workbooks._________________________

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

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.

Identify the letter of the choice that best matches the phrase or definition. -Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

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

All template files have a(n)____ extension.

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

If the destination file is closed when you make a change in the ____ file,you can choose whether to update the link to display the current values when you open the destination file.

Identify the letter of the choice that best matches the phrase or definition. -​Receives the information when two files are linked