Deck 12: Collaborating on a Shared Workbook

Question 1

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

Answer 1

  True

Question 2

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

Answer 2

  False
single

Question 3

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

Answer 3

  True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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 16

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

Question 17

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 18

Excel workbooks are shared by default.

Question 19

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

Question 20

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

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 23

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

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 25

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 26

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

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

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

Question 28

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 29

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 30

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 31

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 32

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

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

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

Question 35

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 36

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 37

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 38

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

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

Question 39

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 40

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 41

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

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 42

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

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

Question 44

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) 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 45

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? 

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

Question 46

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

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

Question 47

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

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 48

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 49

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 50

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

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

Question 51

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 52

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? 

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

Question 53

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 54

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

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

Question 55

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? 

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

Question 56

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? 

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

Question 57

_______ displays and stores an object within the destination file.

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

Question 58

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

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

Question 59

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 60

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.

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 61

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
​This is a workbook that can be edited by more than one user at the same time

Question 62

Explain which of the following screen elements are part of the Excel window,the workbook window,and the worksheet: formula bar,ScreenTips,chart element names on hover,horizontal and vertical scroll bars,row and column headers,sheet tabs,and gridlines.

Question 63

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Provider of verified digital signatures

Question 64

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Defined and created specifically for a workbook

Question 65

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Stored within the destination file and remains connected to the source file

Question 66

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
An attachment to a document that authenticates the source of the signature

Question 67

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Stored within the destination file and is no longer part of the source file

Question 68

Describe how you can control Excel recalculating Formulas.Discuss the Automatic,Automatic except for data tables,and Manual options.

Question 69

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
A file format developed by Adobe Systems for displaying formatted documents containing text,graphics,and complicated layouts

Question 70

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
The process by which a file is encoded so that it cannot be opened without the proper password

Question 71

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Contains the object that is displayed in the destination file

Question 72

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Refers to the technology that allows one to copy and paste objects

Question 73

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
​Where a list of the changes made to the workbook are stored

Question 74

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

Question 75

Identify the letter of the choice that best matches the phrase or definition.
a.linked object
b.embedding object
c.PDF (Portable Document Format)
d.Standard properties
e.Custom properties
f.Object linking and embedding (OLE)
g.Encryption
h.digital certificate
i.certificate authority (CA)
j.source file
Associated with all Office files and include the author,title,and subject