Deck 12: Collaboration Features for Workbooks

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

B

Question 3

A(n) ____ like the one shown in the accompanying figure can be used to provide a reminder to the user.

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

Answer 3

B

Question 4

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

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

Question 5

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 6

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 7

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

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

Question 8

Which of the following is the path to the Gridlines check box?

A) (REVIEW tab | Page Setup group)
B) (PAGE LAYOUT tab | Page Setup group)
C) (INSERT tab | Worksheet Layout group)
D) (VIEW tab | Show group)

Question 9

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

Question 10

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

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

Question 11

Which of the following is the path to opening the Page Setup dialog box?

A) (FORMULAS tab | Page Setup Dialog Box Launcher)
B) (PAGE LAYOUT tab | Page Setup Dialog Box Launcher)
C) (INSERT tab | Page Setup Dialog Box Launcher)
D) (DEV

Question 12

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

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

Question 13

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) Page Layout

Question 14

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

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

Question 15

You can tap or 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 16

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

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

Question 17

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 | Page Setup group)
D) (PAGE LAYOUT tab | Sheet Options group)

Question 18

The Highlight Changes command is located on the ____ menu.

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

Question 19

____ are descriptions which do not regularly appear as part of a worksheet's data.

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

Question 20

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

A) (VIEW tab | Comments group)
C) (DEV

Question 21

Which of the following is the path to the 'Add a Hyperlink' button?

A) (INSERT tab | Links group)
B) (PAGE LAYOUT tab | Links group)
C) (VIEW tab | Links group)
D) (DEV

Question 22

Which of the following is the path to the Cell Styles button?

A) (VIEW tab | Styles group)
B) (HOME tab | Styles group)
C) (PAGE LAYOUT tab | Styles group)
D) (CELL FORMATTING tab | Styles group)

Question 23

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

A) track changes
B) sharing
C) exclusivity
D) either a or b

Question 24

You can press ____ to display the Hyperlink dialog box.

A) CTRL+B
B) CTRL+H
C) CTRL+I
D) CTRL+K

Question 25

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 26

____ are used in XML files to describe data items.

A) Tabs
B) Tables
C) Tags
D) Tips

Question 27

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

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

Question 28

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 29

The ____ prefix is a standard prefix for email hyperlinks, which Excel adds automatically.

A) sendto:
B) forwardto:
C) mailto:
D) none of the above

Question 30

You can click the ScreenTip button in the ____ dialog box to add ScreenTip text to a hyperlink.

A) Modify Hyperlink
B) Format Hyperlink
C) Insert Hyperlink
D) Prepare Hyperlink

Question 31

XML data always is imported as a(n) ____.

A) key set
B) index
C) roster
D) table

Question 32

You can import an XML file into a workbook by clicking the Import button ____.

A) (INSERT tab | XML group)
C) (DEV

Question 33

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 34

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 35

After testing a hyperlink, the link's formatting is changed to the ____ style.

A) Followed Hyperlink
B) Clicked Link
C) Used Hyperlink
D) Closed Link

Question 36

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 37

A ____ is a special type of XML file used to describe the layout of data in other XML files.

A) note
B) schema
C) tag
D) table

Question 38

A(n) ____ is a schema added to an Excel workbook.

A) XML map
B) digital certificate
C) tag
D) element

Question 39

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

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

Question 40

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 41

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

Question 42

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

Question 43

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 44

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 45

Which of the following are effective workbook collaboration options?

A) Distributing a workbook to others physically or electronically
B) Sharing a workbook
C) Participating in discussion threads or online meetings using a service, such as SharePoint Services with Microsoft Office 2013
D) Pasting a workbook object on a PowerPoint slide

Question 46

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

Question 47

Excel allows you to share and collaborate with others through a variety of features, depending on ____.

A) your resources
B) collaborators' resources
C) your preferences
D) collaborators' preferences

Question 48

You must first unhide comments before you can edit them.

Question 49

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 50

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

Question 51

You can edit a comment using a shortcut menu.

Question 52

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

Question 53

Calibrated changes are the electronic version of sticky notes.

Question 54

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

Question 55

Excel keeps a change history with each shared workbook.

Question 56

Excel erases the change history when track changes is enabled.

Question 57

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 58

You can ____ comments.

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

Question 59

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

Question 60

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

Question 61

A(n) ____________________ is faded text overlaid on the worksheet, used to convey something about the state of the worksheet, often an indicator of status, such as Draft or Confidential.

Question 62

You can quickly read a hidden comment by pointing to a cell's comment indicator. _________________________

Question 63

A(n) ____________________, as shown in the accompanying figure, indicates a comment.

Question 64

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

Question 65

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

Question 66

After a(n) shared workbook is protected, no one can unprotect or change it except the owner. _________________________

Question 67

You can display the Format Comment dialog box by ____________________ selected comment text and then clicking the Format Comment command.

Question 68

Tracking and formatting work together. _________________________

Question 69

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

Question 70

If both you and another user change the same cell in a shared workbook, Excel displays a(n) ____________________ dialog box when the workbook is saved.

Question 71

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

Question 72

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

Question 73

The needs of the people with whom you will be collaborating are determined by the resources they have. _________________________

Question 74

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

Question 75

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

Question 76

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

Question 77

Workbooks to be merged can have different passwords.

Question 78

____________________ allows users to bring together copies of workbooks that others have worked on independently.

Question 79

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 80

Merging multiple copies of a workbook requires no special setup.