Deck 11: Collaboration Features for Workbooks

Question 1

____ are the electronic version of sticky notes or annotations in the margin.

A) Comments
B) Tracked changes
C) Custom views
D) Themes

Answer 1

A

Question 2

You can open the ____ view and then click the Share tab to view options for distributing a workbook.

A) Backstage
B) Full Screen
C) Normal
D)

Answer 2

A

Question 3

You can click the ____ button to turn on / off the view of all comments.

A) View All Comments
B) Display All Comments
C) Comments On / Off
D) Show All Comments

Answer 3

D

Question 4

Which of the following is the path to the Delete Comment button?

A) (VIEW tab | Comments group)
B) (REVIEW tab | Comments group)
C) (DEVELOPER tab | Comments group)
D) (INSERT tab | Comments group)

Question 5

You can press ____ to add a new comment to a worksheet.

A) SHIFT+F3
B) CTRL+F2
C) SHIFT+F2
D) ALT+F3

Question 6

By default,Excel keeps a change history of ____ days for a shared workbook.

A) 10
B) 20
C) 30
D) 40

Question 7

To password-protect a shared workbook,click the ____ button (REVIEW tab | Changes group).

A) Workbook Password Assignment
B) Protect Shared Workbook
C) Share Protected Workbook
D) none of the above

Question 8

The 'Accept / Reject Changes' command is located on the ____ menu.

A) Modify Changes
B) Track Changes
C) Select Changes
D) Review Changes

Question 9

You can click the ____ command on the shortcut menu to remove a comment from a worksheet.

A) Remove Comment
B) Expunge Comment
C) Delete Comment
D) Hide Comment

Question 10

Each copy of a workbook to be merged must have a different ____.

A) password
B) path
C) file name
D) number of worksheets

Question 11

A workbook which is not shared and can be opened only by a single user is called an ____ workbook.

A) exclusive
B) embargoed
C) engaging
D) enabled

Question 12

A(n)____ can be used to provide a reminder to the user.

A) clone
B) watermark
C) formatted shape
D) indexed transparency

Question 13

Which of the following is the path to the Background button?

A) (PAGE LAYOUT tab | Scale to Fit group)
B) (PAGE LAYOUT tab | Themes group)
C) (PAGE LAYOUT tab |

Question 14

Which of the following is the path to the Track Changes button?

A) (REVIEW tab | Changes group)
B) (INSERT tab | Changes group)
C) (HOME tab | Changes group)
D) (VIEW tab | Changes group)

Question 15

The Highlight Changes command is located on the ____ menu.

A) Protect Changes
B) Show / Hide Changes
C) Make Changes
D) Track Changes

Question 16

You can click the 'Insert a Comment' button ____ to add a new comment to a worksheet.

A) (VIEW tab | Comments group)
B) (REVIEW tab | Comments group)
C) (HOME tab | Comments group)
D) (INSERT tab | Comments group)

Question 17

____ work well when multiple people are collaborating and commenting on a worksheet.

A) Calibrated changes
B) Custom views
C) Comments
D) Themes

Question 18

Which of the following is the path to the Protect Share Workbook button?

A) (REVIEW tab | Comments group)
B) (REVIEW tab | Changes group)
C) (REVIEW tab | Proofing group)
D) (REVIEW tab | Sharing group)

Question 19

____ means working together in cooperation on a document with other Excel users.

A) Collaboration
B) Tracking changes
C) Adding comments
D) Distribution

Question 20

If either ____ or sharing is enabled,Excel enables the other by default.

A) distributing
B) formatting
C) collaborating
D) tracking

Question 21

Comments added by each user are identified by a name in the comment,set by the user.

Question 22

Which of the following are effective workbook collaboration options?

A) Sharing a workbook
B) Participating in discussion threads or online meetings using a service,such as SharePoint Services with Microsoft Office 2016

Question 23

Which of the following are options you can click in the Select Changes to Accept or Reject dialog box?

A) When
B) How
C) Who
D) Where

Question 24

Which of the following are disabled when workbook sharing is enabled?

A) Deleting worksheets
B) Changing passwords
C) Using scenarios
D) Using data validation

Question 25

Which of the following is the path to the 'View Side by Side' button?

A) (VIEW tab | Zoom group)
B) (VIEW tab | Show group)
C) (VIEW tab | Workbook Views group)
D) (VIEW tab | Window group)

Question 26

When the copies of a workbook to be merged into a single workbook are made,____ must be enabled.

A) track changes and sharing
B) review tab
C) exclusivity
D) passwords

Question 27

You can ____ comments.

A) format
B) resize
C) copy
D) move

Question 28

Shared workbooks must be ____ within the number of days specified to record the change history.

A) tracked
B) merged
C) saved
D) circulated

Question 29

You must first unhide comments before you can edit them.

Question 30

Which of the following is the path to the Custom Views button?

A) (VIEW tab | Show group)
B) (VIEW tab | Workbook Views group)
C) (VIEW tab | Window group)
D) (VIEW tab | Display group)

Question 31

You can add a new comment by clicking the Insert Comment command on a shortcut menu.

Question 32

Which of the following buttons will enable two worksheets to scroll at the same time so that you can make a visual comparison of the workbooks?

A) Reset Window Position
B) Synchronous Scrolling
C) Dual Scroll
D) Active Scroll

Question 33

Calibrated changes are the electronic version of sticky notes.

Question 34

You can add buttons to the Quick Access Toolbar with options in the ____ dialog box.

A) Excel Options
B) Add-Ins
C) Check for Issues
D) Protect Workbook

Question 35

When a workbook is shared with other users,changes made and saved by the other users are visible only when you attempt to save changes.

Question 36

You can show or hide comments on the worksheet,but you cannot print them.

Question 37

You can click the ____ button in the Custom Views dialog box to delete a custom view.

A) Delete
B) Show
C) Add
D) Remove

Question 38

You can edit a comment using a shortcut menu.

Question 39

Excel has the capability to mark who changed what data,in which cell,and when.

Question 40

You can use a background image,or watermark,as a worksheet's background.

Question 41

After clicking the View Side by Side button,the arrangement of workbooks on your screen depends on how previous Excel windows were arranged.

Question 42

Excel erases the change history when track changes is enabled.

Question 43

It is highly unusual to find different versions of software being used within the same company.

Question 44

Excel keeps a change history with each shared workbook.

Question 45

Merging multiple copies of a workbook requires no special setup.

Question 46

The best way to note suggestions and changes to a worksheet is to write the suggestions on a printed draft copy of the worksheet and send it to the person in charge of the workbook.

Question 47

Which of the following is the path to the Unprotect Sheet button?

A) (FORMULAS tab | Changes Auditing group)
B) (REVIEW tab | Changes group)
C) (HOME tab | Changes group)
D) (DATA tab | Changes group)

Question 48

You cannot review changes when you click the Accept All button in the Accept or Reject Changes dialog box.

Question 49

Sharing workbooks allows users to view and scroll worksheets side by side._________________________

Question 50

When you save a workbook in an accessible location on OneDrive,you need to make a workbook available to others.

Question 51

The Protect Sheet button is located on the _____ tab.​

A) ​CODE
B) ​PROTECT
C) ​DEVELOPER
D) ​REVIEW

Question 52

You must save a shared workbook before you are notified of another user's changes.

Question 53

In order to merge multiple workbooks,each workbook must be a copy of the same workbook.

Question 54

When working with multiple copies of the same workbook,the same cell can contain different values in the various copies of the workbook.

Question 55

Saving on OneDrive to distribute workbooks by necessity differs from saving on OneDrive when saving your own files.

Question 56

When Excel recognizes that another user has modified a shared workbook,Excel displays a dialog box indicating that the workbook has been updated with changes saved by other users.

Question 57

Turning off track changes also turns off sharing and saves the workbook.

Question 58

To share a workbook you must post it to a network server.

Question 59

​You can add the DEVELOPER tab to the Ribbon with options in the _____ dialog box.

A) ​Customize Ribbon
B) ​Main Tabs list
C) ​Trust Center
D) ​none of the above

Question 60

Workbooks to be merged can have different passwords.

Question 61

In which of the following modes can you set the properties that determine a control's appearance and behavior?​

A) ​Run
B) ​Design
C) ​Execute
D) ​Modify

Question 62

Each ActiveX control available n the Controls gallery has many _____.​

A) ​properties
B) ​facets
C) ​names
D) ​none of the above

Question 63

_____ controls require no knowledge of VBA to be used.​

A) ​Dynamic object
B) ​Form
C) ​ActiveX
D) ​Worksheet management

Question 64

You can use the _____ form control to position a set of option buttons together.​

A) ​Group Box
B) ​Spin Button
C) ​Label
D) ​Scroll Bar

Question 65

Comments can be placed at any of the following positions EXCEPT _____​.

A) ​in between lines of code
B) ​before the Supplement statement
C) ​at the end of a line of code
D) ​before the Sub statement