Deck 11: Collaboration and Workbook Distribution

Question 1

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

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

Answer 1

B

Question 2

Which of the following is not a Property in Excel?

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

Answer 2

D

Question 3

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.

Answer 3

C

Question 4

Which of the following is not an Excel Options category?

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

Question 5

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

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

Question 6

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 7

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 8

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 9

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

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

Question 10

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

Question 11

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

Question 12

Which of the following is not customizable in Excel?

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

Question 13

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 14

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 15

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 16

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

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

Question 17

The default setting for printing comments is ________.

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

Question 18

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 19

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

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

Question 20

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 21

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

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 24

Track Changes works only on ________ workbooks.

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

Question 25

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

Question 26

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 27

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 28

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 29

A file with an .ods extension is ________.

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

Question 30

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 31

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 32

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

Question 33

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 34

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 35

What cloud based storage service is integrated in Excel 2016?

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

Question 36

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

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

Question 37

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

Question 38

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 39

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 40

What is the default file format for Excel 2016?

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

Question 41

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

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

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

Question 45

The Share Workbook command is on the ________ tab.

Question 46

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

Question 47

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

Question 48

The ________ checks a workbook for personal data.

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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 54

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

Question 55

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

Question 56

The default email client associated with Excel is ________.

Question 57

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

Question 58

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

Question 59

________ is the cloud service integrated with Excel 2016.

Question 60

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

Question 61

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

Question 62

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

Question 63

The Quick Access Toolbar cannot be modified.

Question 64

Shared workbooks must be in read-only network drives.

Question 65

Merge Cells is available while change tracking is turned on.

Question 66

Advanced Properties display above the current workbook.

Question 67

The Document Inspector can remove personal data from a workbook.

Question 68

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

Question 69

Change tracking is available only in shared workbooks.

Question 70

You can export Quick Access Toolbar settings to other users.

Question 71

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

Question 72

The user cannot change automatically updated properties.

Question 73

Excel uses no metadata in its files.

Question 74

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

Question 75

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

Question 76

The Excel Options dialog box is on the Developer tab.

Question 77

Google docs and OpenOffice use ________ file extensions for spreadsheets.

Question 78

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

Question 79

A workbook marked as final is shared.

Question 80

Hidden comments do not print.