Exam 6: Managing Multiple Worksheets and Workbooks

If you trust the provider of source files,you can choose to ____ the content,which allows the external reference formulas to function and updates the links in the destination workbook.

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

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

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

A template can use most Excel features except macros.

If Excel has not attempted to update the links in a given session,the Edit Links dialog box will show the status of the links as not checked._________________________

The interface for the Excel Web App is similar to the interface of the full-featured program on your computer;however,only a limited number of ________________ are available.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates that a link has to be updated manually by the user

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

The ____ caption indicates a worksheet group.

The active worksheet in a group is indicated by ____ text.

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

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

The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.

The default template has ____ worksheets inserted in the workbook.

When you start Excel and see the blank workbook called Book1,you are actually using the ____________________ template.

The ____ button on the Ribbon is used to create a hyperlink.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Collection of two or more selected worksheets

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

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