Exam 12: Collaborating on a Shared Workbook

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

Identify the letter of the choice that best matches the phrase or definition. -A file format developed by Adobe Systems for displaying formatted documents containing text,graphics,and complicated layouts

Case 12-2 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. -Comments are a powerful collaboration tool,giving team members the ability to offer insights and make suggestions about the workbook and its content.Now Rebecca would like to review the comments by clicking the _______.

The running conversation among users about a cell is displayed within a(n)double comment box connected to that cell._________________________

A final way to ensure that a document has not been changed by an unauthorized user is with a(n)________ signature,which can be thought of as an electronic version of a written signature.

Identify the letter of the choice that best matches the phrase or definition. -​Where a list of the changes made to the workbook are stored

To change the length of the tracking log history,specify a new length in _______ on the Advanced tab in the Share Workbook dialog box.

Passwords can be up to _______ characters and can include numbers,symbols,uppercase letters,and lowercase letters.

The contents of the _______ log can be reviewed either in the form of comments attached to the edited cells,or within a list displayed in a separate worksheet.

_______ occur when users try to save different values in the same cell.

To capture a screen image,click the _______ tab on the ribbon,and then click the Screenshot button in the Illustrations group.

The Standard option optimizes the PDF for use with online publishing and printing._________________________

_______ properties are properties created for organizations to use in designing and distributing electronic forms.

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

Case-Based Critical Thinking Questions Case 12-1 Chloe is building a kiosk-based Excel application.She wants to make some modifications to the screen elements in order to keep users from being distracted by parts of the application that are irrelevant to her application.She turns to Henry for guidance as she knows he built a similar solution earlier this year. -Where in the Excel Options dialog box would Chloe find the setting to turn off AutoComplete for cell values? 

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

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

Document properties or metadata are the descriptive details about a workbook.

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

Word _______ a linked object every time you open the Word document or any time the Excel source file changes while the Word document is open.