Exam 6: Managing Multiple Worksheets and Workbooks

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

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

Using multiple worksheets makes it more difficult for you to group your data.

When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.

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

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

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

To use a template that you create,the template file is typically placed in the ____________________ folder.

To select adjacent worksheets,you use the ____ key.

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. -After Brook 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?

The ____ template in Excel creates an online time card to track employees' work hours.

Excel,by default,looks for template files in the $\underline { \text { Templates } }$ folder,which is where custom template files are often stored._________________________

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.

After you have saved a template,you can access the template from the New screen in ____________________ view.

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

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?

A link is a connection between two ____ allowing information to be transferred from one to the other.

Hyperlinks are usually represented by words with colored letters and $\underline { \text { underlines } }$ or images._________________________

MATCHING 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

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