Deck 41: Collaboration and Workbook Distribution: Hands On Exercise Videos

Question 1

You annotate a cell with a reminder by inserting a ________.

A)memo
B)notation
C)comment
D)note

Answer 1

C

Question 2

When saving a workbook to the Web,you click your ________ account in the Save As pane.

A)Facebook
B)iCloud Storage
C)SkyDrive
D)Google Cloud Storage

Answer 2

C

Question 3

You CANNOT retrieve a lost SkyDrive password.

Answer 3

False

Question 4

To change the author name,you click Options on the FILE tab and enter the new author name.

Question 5

You use the ________ to find any content that might cause difficulties for users.

A)Accessibility Inspector
B)Accessibility Checker
C)Content Inspector
D)Content Checker

Question 6

You can display the ________ between the Ribbon and the Formula Bar so the document properties are always shown.

A)Document Properties Panel
B)Document Information Panel
C)Document Properties Pane
D)Document Information Pane

Question 7

You use the ________ to find personal data stored in the workbook or personal document properties.

A)Privacy Checker
B)Privacy Inspector
C)Document Checker
D)Document Inspector

Question 8

You would use the ________ command to indicate a workbook is complete and to make the file read-only.

A)Lock Workbook
B)Finalize Workbook
C)Mark as Completed
D)Mark as Final

Question 9

To delete a comment from a cell,you:

A)double-click the cell and select Delete Comment.
B)right-click the cell and select Delete Comment.
C)click in the comment and click Cut on the HOME tab.
D)click in the comment and Press Delete.

Question 10

To edit a comment,you click in the comment and make the desired changes.

Question 11

To change the user name,you click Info on the FILE tab and enter the new user name.

Question 12

To distribute a workbook to others so that it retains the same format and cannot be changed,you would save the workbook as a(n)________ file.

A)PDF
B)RTF
C)XLSX
D)TXT

Question 13

When a workbook is shared,[Shared] is displayed after the file name on the title bar.

Question 14

Information such as author,title,and keywords are examples of document ________.

A)properties
B)descriptions
C)identifiers
D)attributes

Question 15

Check Compatibility is used to verify that critical Excel 2013 features are not lost when a workbook is opened in an earlier version of Excel.

Question 16

A cell with a comment is indicated by ________.

A)a red triangle in the top-right corner of the cell
B)italicizing the cell text
C)bolding the cell text
D)a red cell background

Question 17

Only shared workbooks can be compared and merged.