Deck 12: Collaborating on a Shared Workbook

Question 1

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

Answer 1

False

Question 2

Excel workbooks are shared by default.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

$\underline{\text { Standard properties }}$ are properties associated with all Office files and include the author,title,and subject._________________________

Question 10

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

Question 11

Screen elements that are part of the worksheet are modified only in that worksheet and not in other worksheets and workbooks.

Question 12

The Microsoft file hosting service offers seven $\underline {\text { megabytes } }$ of free storage for new users with the option to purchase additional storage space._________________________

Question 13

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.

Question 14

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

Question 15

The $\underline {\text { Standard }}$ option optimizes the PDF for use with online publishing and printing._________________________

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

A)when
B)how
C)why
D)where

Question 22

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

A)merged
B)shared
C)saved
D)combined

Question 23

The item marked 1 in the accompanying figure is checked to _______.

A)allow individual editing of the workbook
B)allow simultaneous editing of the workbook
C)allow alternate editing of the workbook
D)allow consecutive editing of the workbook

Question 24

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.

A)saved
B)copied
C)erased
D)backed up

Question 25

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

A)beginning
B)ending
C)source
D)original

Question 26

In the accompany figure,item _______ identifies the date and time of the edit.

A)1
B)2
C)3
D)5

Question 27

In the accompanying figure,item _______ displays the location of the edit.

A)1
B)2
C)3
D)4

Question 28

_______ properties are properties associated with all Office files and include the author,title,and subject.

A)Custom
B)Standard
C)Automatically updated
D)Organization

Question 29

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

A)Issues
B)Errors
C)Problems
D)Conflicts

Question 30

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.

A)tracking
B)recording
C)mapping
D)documenting

Question 31

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

A)list of users removed from editing the workbook
B)list of edits added to the document
C)list of users currently editing the workbook
D)list of previous users currently editing the workbook

Question 32

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

A)Document Library
B)Standard
C)Custom
D)Organization

Question 33

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

A)months
B)days
C)years
D)hours

Question 34

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

A)Custom
B)Document library
C)Organization
D)Automatically Updated

Question 35

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

A)sky
B)cloud
C)external drive
D)satellite

Question 36

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

A)group
B)interactive
C)collaborative
D)sharing

Question 37

The wide collection of file hosting sites that allow document sharing supported by the Internet include _______.

A)Symphony
B)Google Docs
C)Sortbox
D)FaceDocs

Question 38

In the accompanying figure,item _______ displays the description of the edit.

A)1
B)3
C)4
D)5

Question 39

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

A)simultaneously
B)individually
C)consecutively
D)separately

Question 40

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

A)The copies must originate from different shared files.
B)The copies cannot have different filenames.
C)The Track Changes feature must be turned off for all copies.
D)The copies must either have the same password or not be password-protected.

Question 41

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

A)source
B)individual
C)contact
D)macro

Question 42

In the accompanying figure,item 2 displays _______.

A)a signed workbook marked as final
B)a visible signature in the workbook that certifies the document
C)a signed workbook marked as closed
D)a verified signature in the workbook that certifies the document

Question 43

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.

A)digital
B)electronic
C)automated
D)verified

Question 44

_______ displays and stores an object within the destination file.

A)Copy and Paste
B)Linking
C)Embedding
D)Inserting

Question 45

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

A)source
B)object
C)beginning
D)completed

Question 46

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

A)function
B)formula
C)format
D)references

Question 47

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

A)similar to
B)different from
C)modified from
D)copied from

Question 48

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

A)Copy and Paste
B)Linking
C)Embedding
D)Inserting

Question 49

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

A)Worksheet size
B)International dates
C)Sparklines
D)All of the above

Question 50

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

A)DOCX
B)PDF
C)XPS
D)HTML

Question 51

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

A)embedded object
B)linked object
C)inserted object
D)copied object

Question 52

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

A)destination
B)source
C)object
D)original

Question 53

In the accompanying figure,item 1 displays _______.

A)a signed workbook that is marked as final
B)a visible signature in the workbook that certifies the document
C)a signed workbook that is marked as closed
D)a verified signature in the workbook that certifies the document

Question 54

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

A)Switzerland
B)India
C)Brazil
D)Denmark

Question 55

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

A)write-only
B)read-only
C)locked
D)protected

Question 56

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.

A)Document Properties
B)Document Inspector
C)Document Specifications
D)Document Search

Question 57

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

A)8
B)16
C)255
D)164

Question 58

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

A)
B)
C)
D)

Question 59

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

A)
B)
C)
D)

Question 60

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

A)INSERT
B)HOME
C)FORMULAS
D)VIEW

Question 61

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

A)View Tab, then click Next in the Comments groups
B)Review Tab, then click Next in the Comments groups
C)Home Tab, then click Next in the Comments groups
D)Edit Tab, then click Next in the Comments groups

Question 62

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?

A)Customization dialog box
B)Screen Elements dialog box
C)Excel Options dialog box
D)Display Options dialog box

Question 63

____________________ properties are properties you define and create specifically for a workbook.

Question 64

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.

Question 65

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)Placing the file on the local drive
B)Placing the file on the cloud
C)Placing the file on flash drive
D)Placing the file on a CD-ROM

Question 66

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?

A)taskbar
B)window
C)Windows
D)status

Question 67

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

Question 68

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.

Question 69

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

Question 70

You can accept an edit to keep its new value,or you can ____________________ an edit to return to the original value.

Question 71

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

A)click the Track Changes button in the Changes group, and then click Highlight Changes.
B)click the Track Changes button in the Language group, and then click Highlight Changes.
C)click the Track Changes button in the Comments group, and then click Highlight Changes.
D)click the Track Changes button in the Proofing group, and then click Highlight Changes.

Question 72

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?

A)Advanced options, Display section
B)Advanced options, Editing options section
C)Save options
D)Formulas options

Question 73

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.

A)Allow changes by more than one user at different times
B)Allow changes by only one user at the same time
C)Allow changes by more than one user at the same time
D)Remove users

Question 74

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?

A)In that worksheet
B)In any worksheets
C)In any workbooks
D)In all worksheets

Question 75

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.

A)updates
B)changes
C)copies
D)saves

Question 76

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

A)Share Workbook dialog box
B)Trust Center dialog box
C)Proofing dialog box
D)Comments dialog box

Question 77

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.

Question 78

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

Question 79

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)Advanced options, Display section
B)Advanced options, Editing options section
C)Save options
D)Formulas options

Question 80

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.