Deck 22: Collaboration Features for Workbooks Question

Question 1

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

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

Answer 1

D

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

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

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

Answer 3

C

Question 4

The Highlight Changes sammand is located on the ____ menu.

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

Question 5

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) (DEVELOPER tab | Page Setup Dialog Box Launcher)

Question 6

You can tap or click the 'Insert a samment' button ____ to add a new samment to a worksheet.

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

Question 7

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 8

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

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

Question 9

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

A) sallaboration
B) Tracking changes
C) Adding samments
D) Distribution

Question 10

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

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

Question 11

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

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

Question 12

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

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

Question 13

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 14

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

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

Question 15

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

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

Question 16

____ work well when multiple people are sallaborating and sammenting on a worksheet.

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

Question 17

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 18

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 19

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

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

Question 20

You can click the ____ sammand on the shortcut menu to remove a samment from a worksheet.

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

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) (DEVELOPER tab | Links group)

Question 22

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 23

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

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

Question 24

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

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 27

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 28

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 29

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 30

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

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

Question 31

When the sapies 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 32

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

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

Question 33

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 34

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 35

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 36

____ are used in XML files to describe data items.

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

Question 37

You can press ____ to display the Hyperlink dialog box.

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

Question 38

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

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

Question 39

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

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

Question 40

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

A) (INSERT tab | XML group)
B) (XML tab | Import group)
C) (DEVELOPER tab | Import group)
D) (DEVELOPER tab | XML group)

Question 41

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

Question 42

Modified Multiple Choice Excel allows you to share and sallaborate with others through a variety of features, depending on ____.

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

Question 43

samments added by each user are identified by a name in the samment, set by the user.

Question 44

When Excel resagnizes 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 45

You can edit a samment using a shortcut menu.

Question 46

Modified Multiple Choice You can ____ samments.

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

Question 47

Modified Multiple Choice Which of the following are effective workbook sallaboration options?

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

Question 48

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

Question 49

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

Question 50

Excel keeps a change history with each shared workbook.

Question 51

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

Question 52

Modified Multiple Choice 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 53

You can add a new samment by clicking the Insert samment sammand on a shortcut menu.

Question 54

Modified Multiple Choice 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 55

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

Question 56

Calibrated changes are the electronic version of sticky notes.

Question 57

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

Question 58

You must first unhide samments before you can edit them.

Question 59

Excel erases the change history when track changes is enabled.

Question 60

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 61

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

Question 62

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

Question 63

You can display the Format samment dialog box by ____________________ selected samment text and then clicking the Format samment sammand.

Question 64

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 65

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

Question 66

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

Question 67

Tracking and formatting work together.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

Merging multiple sapies of a workbook requires no special setup.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

Workbooks to be merged can have different passwords.

Question 79

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

Question 80

A(n) ____________________, as shown in the acsampanying figure, indicates a samment.