Deck 28: Excel : Collaboration and Workbook Distribution

Question 1

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

Answer 1

A

Question 2

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

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

Answer 2

D

Question 3

Which Excel Options category contains Editing options?

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

Answer 3

B

Question 4

Which of the following is not an Excel Options category?

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

Question 5

Where do you access the Excel Options dialog box?

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

Question 6

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

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

Question 7

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 8

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 9

AutoCorrect options are located in which Excel Options category?

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

Question 10

Where is the Share Workbook command located within Excel?

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

Question 11

The default comment print setting is:

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

Question 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

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 16

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

Question 17

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 18

Where is the New Comment command located?

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

Question 19

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 20

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

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

Question 21

Which of the following is a feature of change tracking?

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

Question 22

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 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 an integrated option for sending files to others?

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

Question 26

Where is the Track Changes feature located?

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

Question 27

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

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

Question 28

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 29

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 30

What is the default file format in Excel 2013?

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

Question 31

Which of the following changes will Excel not track?

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

Question 32

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 33

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

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

Question 34

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

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

Question 35

Which dialog box allows the user to print all comments?

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

Question 36

Where is the Accessibility Checker located?

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

Question 37

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 38

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 39

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 40

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

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

Question 41

Change tracking can only be activated in shared workbooks.

Question 42

The Quick Access Toolbar can be customized.

Question 43

A workbook marked as final cannot be password protected.

Question 44

Shared workbooks cannot be marked as final.

Question 45

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

Question 46

Workbook comments can only be removed one at a time.

Question 47

Documents can have multiple authors defined in the document properties.

Question 48

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

Question 49

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

Question 50

A workbook marked as final is read-only.

Question 51

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

Question 52

Hidden comments do not print.

Question 53

Excel can export PDF files.

Question 54

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

Question 55

Customization of the Quick Access Toolbar can be exported.

Question 56

The user cannot change automatically updated properties .

Question 57

The Ribbon cannot be customized.

Question 58

Metadata is attached to each Excel workbook.

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

Excel customization options can be located in the ________ area.

Question 64

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

Question 65

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

Question 66

Excel cannot export .CSV files.

Question 67

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

Question 68

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

Question 69

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

Question 70

The Share Workbook command is located on the ________.

Question 71

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 72

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

Question 73

The ________ can be customized in Excel.

Question 74

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

The Document Inspector will remove personal data from a workbook.

Question 76

Excel cannot save workbooks for previous versions of Excel.

Question 77

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

Question 78

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

Question 79

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

Question 80

A forgotten password within Excel cannot be retrieved.