Exam 12: Collaborating on a Shared Workbook

A(n)_______ is stored within the destination file and remains connected to the source file.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the object that is displayed in the destination file

Assume you have a blank workbook open in Excel.You have clicked on the Sheet1 tab and you are currently in cell A1.Describe the steps you would take to connect to a text file using the Text Import Wizard.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Defined and created specifically for a workbook

____________________ are the conditions that limit the number of records displayed in the results of a query.

To facilitate real-time data acquisition,Excel provides ____________________ the function.

_______ properties are properties associated with documents in a document library on a website or in a public network folder.

Your cousin Rebecca knows that you are an experienced Excel user. She has created a workbook and needs input from three fellow workers. She wants to retain her workbook as the original copy. She will need your help in collecting input. -Rebecca would like to review track changes.In a shared workbook,all edits are stored in a tracking log for 30 days.On the REVIEW tab,she will _______.

A workbook marked as ____________________ has the editing,typing,and proofing commands turned off.

Your cousin Rebecca knows that you are an experienced Excel user. She has created a workbook and needs input from three fellow workers. She wants to retain her workbook as the original copy. She will need your help in collecting input. -Now that Rebecca has saved her workbook in a secure area,she can share the workbook with others.To share the workbook,Rebecca will use the _______.

Another way to collaborate on a document is to provide a separate copy of the same shared file to multiple users.

You can accept an edit to keep its new value,or you can ____________________ an edit to return to the original value.

When using a website as a data source,a(n)____________________ specifies how data should be retrieved from the webpage and indicates exactly which parts of the webpage should be included and which parts should not be included.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and remains connected to the source file

Screen elements that are part of the worksheet are modified only in that worksheet and not in other worksheets and workbooks.

The ____________________ acts like a notary public,verifying signatures and tracking those that have expired or been revoked.

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

$\underline{\text { Standard properties }}$ are properties associated with all Office files and include the author,title,and subject._________________________

The _______ tools in Excel make it simpler for groups to share the work of writing,editing,and finishing a financial report.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A symbol that separates one column of data from another