Exam 12: Collaborating on a Shared Workbook

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A question you ask about the data in a database

A(n)____________________ file contains the object that is displayed in the destination file.

A(n) $\underline { \text { source } }$ file contains the object that is displayed in the destination file._________________________

Excel tracks the changes made to a shared workbook,recording the name of the user who made the changes and _______ the changes were saved.

You can remove sharing from your workbook at any time by reopening the ____________________ screen and editing the list of recipients,removing users who should no longer have access to the file.

An edit can be accepted to keep its new value,or you can reject an edit to return to the _______ value.

In a shared workbook,all edits are stored in a tracking log for 60 days.

An object is anything that appears on your screen that can be selected and manipulated.

A(n) $\underline {\text { linked object }}$ is stored within the destination file and remains connected to the source file._________________________

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

An International format,53,08,421.64 with thousands above 9,999 marked in two-digit groups with a comma,and decimals marked with a period is used in _______.

Excel tracks the changes made to a shared workbook,recording the name of the user who made the changes and when the changes were saved.

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. -Since Rebecca needs to share her workbook with three or more co-workers,she will click _______ in the Shared dialog box.

To make it possible for other users to access and edit the same data _______,you need to share a workbook.

If you do not have a digital certificate,you can get one from a third-party _______,known as a certificate authority (CA).

The Paste option icon that links to the source file and keeps the formatting from the source file is _______.

The different versions of the workbook can be ____________________ so that the changes in the copies can be compared and conflicting edits can be resolved.

The running conversation among users about a cell is displayed within a single ____________________ box connected to that cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Associated with all Office files and include the author,title,and subject

Once workbook sharing is removed,the contents of the tracking log are _______,and there is no way to retrieve the history of edits made to the document.