Site MapHelpFeedbackLesson 18 Quiz
Lesson 18 Quiz
(See related pages)

1
Which of the following statements best defines a shared Excel workbook?
A)A workbook used by more than one worker
B)A workbook saved in the SkyDrive folder
C)A workbook stored in the company folder on a network drive
D)A workbook sent by e-mail to another worker
2
When each worker in a workgroup has his or her own copy of a shared Excel workbook, which of the following statements is most likely to be true?
A)All workers have the same user name.
B)All workers work at the same time.
C)The workbooks are merged at some time.
D)The workbooks are separated at some time.
3
Which of the following tasks is not possible in a shared Excel workbook?
A)Edit values
B)Insert a comment
C)Change column width
D)Use data validation
4
Which of the following statements defines SkyDrive?
A)It is hard drive accessed across company phone lines for shared work.
B)It is an online storage service for Windows users.
C)It is on online suite of free applications for Windows users.
D)It is the storage location for all Office Web Applications.
5
While reviewing edits in a merged Excel workbook, what happens if you reject a change made by another user?
A)The data returns to the original.
B)The data is deleted.
C)The data is set to the most recent change.
D)The data is removed from the column.
6
From the File command tab, which command group is used to save an Excel workbook to a SkyDrive folder?
A)Save to Web
B)Save to Windows Live
C)Save to SkyDrive
D)Save to Internet
7
Which of the following statements about working with edits in a shared Excel workbook is correct?
A)You can accept changes but cannot reject edits to labels.
B)You cannot accept all changes but can reject any change.
C)You can accept any change and reject any change.
D)You can neither accept changes nor reject changes.
8
What is the name of the command that combines multiple user copies of a shared Excel workbook into one workbook?
A)Compare and Merge Workbooks
B)Consolidate Workbooks
C)Track Changes
D)Accept or Reject Changes
9
Which of the following statements about merging copies of a shared Excel workbook is false?
A)The original workbook must have been shared before copies were made.
B)All workbooks must have the same file name and extension.
C)Workbooks must be merged before expiration of the change history days.
D)Each copy of the workbook must have been made from the original.
10
Which of the following command steps does not provide a method for inserting a comment in an Excel workbook?
A)Right-click the cell and choose Insert Comment.
B)Click the Review command tab.
C)Edit a cell in a shared workbook.
D)Click the Insert command tab.







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 18 Quiz