Exam 12: Collaborating on a Shared Workbook

Identify the letter of the choice that best matches the phrase or definition. -An attachment to a document that authenticates the source of the signature

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

Excel automatically recalculates any formula when the input cells to that _______ are changed.

Identify the letter of the choice that best matches the phrase or definition. -Refers to the technology that allows one to copy and paste objects

The Document Inspector will remove comments,annotations,document properties,and personal information from a shared workbook.

To determine whether a workbook contains sensitive or personal information,you use the _______ to search the workbook to locate data and text that you may want removed.

Identify the letter of the choice that best matches the phrase or definition. -Stored within the destination file and is no longer part of the source file

Excel workbooks are shared by default.

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

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. -To begin Rebecca needs to share her workbook.She will create a shared folder.What would be the best way to distribute the workbook to others? 

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

Shared workbooks are usually stored in shared folders located on either a local network or the _______.

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

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. -Chloe has decided to hide the worksheet gridlines and the vertical scroll bar.What does Henry tell her to use to do this? 

To add a digital signature to a document,you need a(n)digital code,which is an attachment to a document that authenticates the source of the signature._________________________

Describe the steps to review tracked changes in a shared workbook.

Encryption is the process by which a file is encoded so that it cannot be opened without the proper password._________________________

One disadvantage of embedded objects is that they tend to greatly increase the size of the _______ file.

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

Digital signatures provide a way for the author to authenticate the document by "signing off" on it.