Exam 12: Collaborating on a Shared Workbook

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 change the default location for Excel workbook files? 

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

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. -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 _______.

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. -If Chloe hides a screen element that is part of the worksheet,where is that screen element hidden? 

The most serious differences between Excel 2016 and older versions of Excel include: _______.

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

Identify the letter of the choice that best matches the phrase or definition. -Provider of verified digital signatures

Marking a workbook as final makes the workbook _______,discouraging a user from making any changes to it.

A _______ Excel workbook tracks the changes made by different people so everyone can examine when and where each change was made.

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. -Henry explains to Chloe that Excel screen elements fall into general categories.Which of the following is one of the categories into which the screen elements fall? 

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

Identify the letter of the choice that best matches the phrase or definition. -​This is a workbook that can be edited by more than one user at the same time

The following condition must be met to merge two or more workbooks: 

_______ properties are properties 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. -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 _______.

_______ displays an object in the destination file,but only stores the location of the source file.

Identify the letter of the choice that best matches the phrase or definition. -The process by which a file is encoded so that it cannot be opened without the proper password

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.

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

The encryption password is _______ the passwords that prevent users from editing a worksheet or the entire workbook.