Deck 42: Collaboration and Workbook Distribution

Question 1

Where do you access the Excel Options dialog box?

A)Backstage
B)Formulas tab
C)Data tab
D)Insert tab

Answer 1

A

Question 2

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

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

Answer 2

B

Question 3

Which of the following scenarios would trigger the Resolve Conflicts dialog box in a shared workbook?

A)Two users attempt to change the same cell at the same time
B)Two users open the same file at the same time
C)Two users attempt to save the same file at the same time
D)Network error

Answer 3

A

Question 4

Which of the following is not true about compare and merge?

A)Each user must save a copy with a unique name
B)Each version of the file must be saved
C)All workbooks must originate from the same file
D)Merged workbooks cannot be exported

Question 5

The default comment print setting is:

A)as displayed on sheet.
B)only active.
C)at end of sheet.
D)none.

Question 6

Which of the following is not a tab located in the Properties dialog box?

A)General
B)Statistics
C)Advanced
D)Custom

Question 7

Which of the following items cannot be added to the Ribbon?

A)Tab
B)Group
C)Software add-in
D)Formula

Question 8

What is the cause of the error message "File in Use"?

A)A user opens a shared workbook
B)A user opens a workbook that is not shared
C)Two users open the same unshared workbook
D)Two users open the same shared workbook

Question 9

Where is the New Comment command located?

A)Data tab
B)Review tab
C)Insert tab
D)View tab

Question 10

What tool is best suited to combine multiple versions of a shared workbook into one document?

A)Merge
B)Concatenate
C)Compare and Merge
D)Combine

Question 11

Which Excel Options category contains Editing options?

A)General
B)Advanced
C)Formulas
D)Trust Center

Question 12

Which of the following is an option to edit a comment?

A)Click Edit Comment in the Comments Group of the Review tab
B)Double click the comment
C)Click Edit Comment in the Comments Group of the Insert tab
D)Comments cannot be edited

Question 13

AutoCorrect options are located in which Excel Options category?

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

Question 14

Which of the following is not true regarding comments in an Excel workbook?

A)Comments are indicated by a black triangle
B)Comments can be edited
C)Multiple users can insert comments
D)There is no limit to the number of comments in a file

Question 15

Author properties can be updated from which category in the Backstage view?

A)Account
B)Info
C)Share
D)Options

Question 16

Which of the following is not a default command of the Quick Access Toolbar?

A)Close
B)Save
C)Undo
D)Redo

Question 17

Where is the Share Workbook command located within Excel?

A)Data tab
B)Insert tab
C)Formulas tab
D)Review tab

Question 18

Which of the following is a limitation of sharing workbooks?

A)125 users can access at once
B)Workbooks that contain tables may not be shared
C)Track changes is not supported
D)The workbook cannot be printed

Question 19

Which of the following is not a customizable feature within Excel?

A)Username
B)Mini Toolbar
C)default font size
D)Backstage

Question 20

Which of the following is not an Excel Options category?

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

Question 21

Which of the following is not a method for protecting the worksheet against changes?

A)Track Changes
B)Add a signature line
C)Export to PDF
D)Mark as Final

Question 22

Which of the following tools is best suited to check the workbook contents to see what data and features are not compatible with previous versions?

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

Question 23

Which of the following tools is best suited for checking a workbook for personal data?

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

Question 24

Which of the following tools is best suited to review your files for potential issues that could hinder the ability of users who access your public files?

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

Question 25

Which of the following is not true about a workbook that is Marked as Final?

A)The file is read-only
B)The file is marked as shared
C)Marked as Final icon appears in the status bar
D)The file is not shared

Question 26

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

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

Question 27

Which of the following is an integrated option for sending files to others?

A)E-mail
B)Dropbox
C)iCloud
D)Google Drive

Question 28

Which of the following is not an option when highlighting changes?

A)Since I last saved
B)Not yet reviewed
C)Reviewed
D)Since date

Question 29

Where is the Track Changes feature located?

A)Data tab
B)Review tab
C)Insert tab
D)Formulas tab

Question 30

Which dialog box allows the user to print all comments?

A)Page Setup
B)Print
C)Page Layout
D)Backstage

Question 31

When tracking changes,which of the following options is no longer available?

A)Conditional formatting
B)Printing
C)Sharing
D)Saving to SkyDrive

Question 32

Which feature is best suited to record edits made to a document over time?

A)Compare and merge
B)Track changes
C)Comments
D)Sharing

Question 33

Which of the following Excel Options categories contains information about protecting your privacy?

A)Save
B)Trust Center
C)Advanced
D)Language

Question 34

What is the default file format in Excel 2013?

A))TXT
B))XLS
C))XLSX
D))XLTX

Question 35

Where is the Accessibility Checker located?

A)Data tab
B)Review tab
C)Backstage
D)Insert tab

Question 36

Which of the following changes will Excel not track?

A)Functions
B)Formulas
C)Deletion
D)Formatting

Question 37

Which of the following is a feature of change tracking?

A)Delete changes
B)E-mail changes
C)Add changes
D)Highlight changes

Question 38

Which of following is the default file format for Excel 97-2003?

A))TXT
B))XLS
C))XLSX
D))XLTX

Question 39

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

A)Table headers
B)Alt text
C)Merged cells
D)Print area

Question 40

Which of the following online storage tools is integrated into Excel 2013?

A)Dropbox
B)iCloud
C)Google Drive
D)SkyDrive

Question 41

Shared workbooks cannot be marked as final.

Question 42

When workbooks are shared users can see changes made by others.

Question 43

An Internet connection is not required to send an Excel workbook via e-mail.

Question 44

When creating a history worksheet using change tracking,the worksheet is automatically saved.

Question 45

The Quick Access Toolbar can be customized.

Question 46

Customization of the Quick Access Toolbar can be exported.

Question 47

The user cannot change automatically updated properties .

Question 48

Workbook comments can only be removed one at a time.

Question 49

A workbook marked as final cannot be password protected.

Question 50

Shared workbooks only function properly on network drives that are read-only.

Question 51

Documents can have multiple authors defined in the document properties.

Question 52

To compare and merge workbooks,the workbooks cannot be shared.

Question 53

A workbook marked as final is read-only.

Question 54

Change tracking can only be activated in shared workbooks.

Question 55

Hidden comments do not print.

Question 56

When active,the Document Panel displays above the current workbook.

Question 57

Excel can export PDF files.

Question 58

The Ribbon cannot be customized.

Question 59

When a signature line is added,the document becomes read-only.

Question 60

Metadata is attached to each Excel workbook.

Question 61

________ is the maximum number of users that can access a shared file at once.

Question 62

When displayed,the ________ will show file properties directly above the current workbook.

Question 63

Users will experience difficulties using shared files on a network drive if the network is ________.

Question 64

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

Question 65

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

Question 66

Excel customization options can be located in the ________ area.

Question 67

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

Question 68

When printing,by default all comments in a worksheet are ________.

Question 69

The ________ can be customized in Excel.

Question 70

A(n)________ can be inserted to provide notes or feedback to other users of a workbook.

Question 71

A forgotten password within Excel cannot be retrieved.

Question 72

The Share Workbook command is located on the ________.

Question 73

Excel cannot export .CSV files.

Question 74

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

Question 75

When a workbook is opened and the message "File in Use" appears,the workbook is ________.

Question 76

The ________ dialog box appears when two users edit the same cell at the same time.

Question 77

Excel cannot save workbooks for previous versions of Excel.

Question 78

________ is the process by which two or more individuals work together to achieve an outcome or goal by using software technology and features in Excel.

Question 79

The Document Inspector will remove personal data from a workbook.

Question 80

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