Exam 12: Collaborating on a Shared Workbook

The running conversation among users about a cell is displayed within a(n) $\underline { \text { double } }$ comment box connected to that cell._________________________

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?

-The item marked 2 in the accompanying figure displays a _______.

$\underline {\text { Encryption }}$ is the process by which a file is encoded so that it cannot be opened without the proper password._________________________

The Excel ____________________ includes most of the tools for editing a workbook that are in the Excel desktop application such as the ribbon,sheet tabs,and command buttons.

The Paste option icon that keeps the formatting applied to the object in the source file is _______.

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

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.

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

Each column of a database table,called a(n)____________________,stores information about a specific characteristic of a person,place,or thing.

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?

-In the accompanying figure,item 1 displays _______.

-In the accompanying figure,item 2 displays _______.

Workbook viruses are often signaled by a hidden worksheet or hidden code attached to the $\underline { \text { HTML } }$ code in the file._________________________

You can accept an edit to keep its new value,or you can $\underline {\text { reject } }$ an edit to return to the original value._________________________

____________________ refers to the technology that allows one to copy and paste objects,such as graphics files,cells and ranges,and charts,so that information about the program that created the object is included with the object itself.

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

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

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

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