Deck 11: Collaboration and Workbook Distribution

Question 1

Which tool is best suited to merge multiple versions of a shared workbook?

A)Combine
B)Compare and Merge Workbooks
C)Side by Side
D)Change manager

Answer 1

B

Question 2

Which of the following is not an option in the Properties dialog box?

A)General
B)Data
C)Summary
D)Statistics

Answer 2

B

Question 3

Track changes ________.

A)records changes to existing cells, but not inserted cells
B)can record changes by eight people
C)exports all changes to a Word document log file
D)records changes to a workbook

Answer 3

D

Question 4

Click the ________ command on the Review Tab to begin tracking changes.

A)Change Log
B)Track Changes
C)Logging
D)Highlight Changes

Question 5

If you didn't use the New Comment command on the Review tab, how would you insert a comment?

A)Use the New Comment command on the Home tab.
B)Right-click and select commenting options.
C)Right-click on the cell and then select Insert Comment.
D)Click comment in the status bar.

Question 6

The Excel Options dialog box primarily ________.

A)manages workbook iterations
B)manages online connections.
C)manages what functions are available
D)manages how Excel behaves and operates

Question 7

The default setting for printing comments is ________.

A)Print in place
B)Print at end
C)not to print
D)only displayed comments

Question 8

Where in the Excel Options dialog box would you manage AutoCorrect options in Excel?

A)General
B)Formulas
C)Proofing
D)Advanced

Question 9

What would happen if two users made changes at the same time in a shared workbook?

A)The Resolve Conflicts dialog box would launch.
B)It would take the first person who opened the file's version.
C)It would take the last person who opened the file's version.
D)An error would appear asking all users to close and re-enter data.

Question 10

What is metadata?

A)The data schema
B)The file path of a file.
C)A tool to measure data quality
D)Data that describes other data

Question 11

Where in the Excel Options dialog box would you manage AutoRecover in Excel?

A)General
B)Formulas
C)Save
D)Advanced

Question 12

Which of the following is not an Excel Options category?

A)General
B)Formulas
C)Proofing
D)Format

Question 13

Which of the following items is not stored as metadata in a workbook?

A)Author
B)Company
C)Imported images
D)Creation date

Question 14

How would you create a new group on a Ribbon tab?

A)Right click on the Ribbon and select new group.
B)You cannot make new groups.
C)Click New Group in the Customize Ribbon section in the Excel Options dialog box.
D)Click on Commands and Groups button in the Customize Ribbon tab in the Excel Options dialog box.

Question 15

A shared workbook is ________.

A)passed from person to person via email
B)limited to four users
C)designed to be stored on a network and be used by multiple people
D)available through any shared link

Question 16

Which of the following is not a Property in Excel?

A)Author:
B)Last Modified By:
C)Tags:
D)Contents of cells

Question 17

How would you return to the default installation settings of the Ribbon?

A)Click Reset in the Customize Ribbon tab of the ExcelOptions dialog box, and then select Reset all customizations, and then click Yes.
B)Click Reset in the customize Ribbon tab of the Excel Options dialog box, and then select Reset Group customizations, and then click Yes.
C)Reinstall Excel.
D)Right Click on the Ribbon and select return to default.

Question 18

Which of the following is not customizable in Excel?

A)User name
B)Backstage view
C)Quick Access Toolbar
D)Default font properties

Question 19

Where in the Excel Options dialog box would you add a word or phrase to AutoCorrect in Excel?

A)Proofing
B)Formulas
C)Save
D)Advanced

Question 20

What is the first step for each user when running the Compare and Merge Workbooks tool?

A)Removing all tables
B)Making all files read only
C)Saving their file with a unique file name
D)Moving all files to a different folder

Question 21

Which of the following is not a tool to check a workbook for issues?

A)File Inspector
B)Compatibility Inspector
C)Document Inspector
D)Accessibility Inspector

Question 22

What happens if you forget your password to a password protected workbook?

A)Send it to your network administrator.
B)It's not restorable.
C)Microsoft can restore it for a fee.
D)Open the Excel Options dialog box and go to Advanced and then click Password Restore.

Question 23

The menu which displays when you click the File tab is the ________.

Question 24

A workbook stored in a network location which displays the File in Use dialog box when accessed by more than one user.

A)Shared
B)Nonsharable
C)Tracked Changes
D)Private View

Question 25

Which tool evaluates the workbook's contents to identify features would be lost if opened in an older version of Excel?

A)Compatibility Checker
B)Accessibility Checker
C)Backwards Compatibility Checker
D)Document Inspector

Question 26

What cloud based storage service is integrated in Excel 2016?

A)iCloud
B)OneDrive
C)Dropbox
D)SyncUp

Question 27

Which of the following is not an option for changes to review in the Select Changes to Accept or Reject dialog box?

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

Question 28

Which of the following is not checked by the Accessibility Checker?

A)Alt Text
B)Merged Cells
C)Print Area
D)Table Headers

Question 29

Excel Workbooks with an X at the end of their extension use what base for building their files?

A)Binary
B)ASCII
C)XML
D)Unicode

Question 30

Which of the following is not a method to protect a workbook against changes?

A)Enable Sharing
B)Add a Signature Line
C)Mark as Final
D)Export as PDF

Question 31

The Office ________ controls the faint image in the top right corner of the title bar.

Question 32

Which option is a good option to send a separate, unshared copy of a workbook?

A)Google Drive
B)email
C)OneDrive
D)Dropbox

Question 33

What is the default file format for Excel 2016?

A).xlsm
B).xltx
C).xls
D).xlsx

Question 34

A file with an .ods extension is ________.

A)Macro-Enabled
B)Binary
C)OpenDocument spreadsheet
D)Portable Document Format

Question 35

The ________is a tool that reviews a workbook for hidden or personal data stored in the workbook or personal document properties.

A)History Worksheet
B)Issue Checker
C)Review Panel
D)Document Inspector

Question 36

Creating a list of changes in a ________ may be a good idea before accepting or rejecting changes.

A)change log
B)history worksheet
C)history log
D)metadata log

Question 37

The Accessibility Checker reviews a document for all of these except ________.

A)Spelling errors
B)Tables with header rows.
C)Objects without Alt text.
D)Hyperlinks without ScreenTips

Question 38

The Office ________ controls the overall appearance and color of the interface of Office.

Question 39

Track Changes works only on ________ workbooks.

A)non-shareable
B)shared
C)read only
D)enabled

Question 40

Which file type preserves data and formatting as it was originally intended and makes it uneditable?

A).pdf
B).xml
C).xlsx
D).docx

Question 41

The ________ checks a workbook for personal data.

Question 42

The default setting is all comments in a worksheet are ________ when printing.

Question 43

History worksheets are ________ when the file is saved.

Question 44

________ is the cloud service integrated with Excel 2016.

Question 45

________ is the process of more than one person working together.

Question 46

If a workbook ________ is lost, it cannot be recovered.

Question 47

Some of the properties you set in the Properties dialog box will make it easier to organize and find files in ________.

Question 48

A(n)________ is a workbook that can be viewed and edited simultaneously by multiple users.

Question 49

A(n)________ colored triangle appears in a cell to indicate a comment.

Question 50

Use the ________ command to combine multiple versions of shared workbooks into one workbook so that you can compare the changes to decide which ones to keep.

Question 51

The ________ dialog box appears if more than one person makes changes in a cell at the same time

Question 52

The Share Workbook command is on the ________ tab.

Question 53

To Mark Workbook as Final, click ________ in the Backstage view.

Question 54

If another user has a ________ workbook open and you try to open it, the File in Use dialog box will display.

Question 55

The Accessibility Checker, Compatibility Checker and the Document Inspector are available in the ________

Question 56

When a file is created, customizations such as the author's name are saved as ________.

Question 57

Files with the ________ extension are formatted as the creator intended and read only and readable by a free downloadable program.

Question 58

A(n)________ is a note to a collaborator containing questions or suggestions about the workbook.

Question 59

The default email client associated with Excel is ________.

Question 60

Use the ________ to make sure your files are backwardly compatible.

Question 61

Advanced Properties display above the current workbook.

Question 62

The .xltx extension is the default format for an Excel ________.

Question 63

Change tracking is available only in shared workbooks.

Question 64

Excel uses no metadata in its files.

Question 65

A workbook marked as final is shared.

Question 66

A comment can be inserted to provide notes or feedback to other users of a workbook.

Question 67

Merge Cells is available while change tracking is turned on.

Question 68

Compatibility Checker checks workbook content tor incompatibility with previous versions of Excel.

Question 69

The user cannot change automatically updated properties.

Question 70

A shared workbook cannot be merged using the Compare and Merge Workbooks tool.

Question 71

A cell that contains a comment is marked with a green triangle.

Question 72

Documents can have only one author defined in the document properties.

Question 73

You can export Quick Access Toolbar settings to other users.

Question 74

Shared workbooks must be in read-only network drives.

Question 75

The Quick Access Toolbar cannot be modified.

Question 76

Hidden comments do not print.

Question 77

The Excel Options dialog box is on the Developer tab.

Question 78

Google docs and OpenOffice use ________ file extensions for spreadsheets.

Question 79

The Document Inspector can remove personal data from a workbook.

Question 80

Users can see the changes made by other users in a shared workbook.