iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 4: Advanced Collaboration

Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

1
Go to the ____ tab and click ____ if you want multiple users to have access to a workbook at the same time.
A)Review; Share Workbook
B)Review; Protect Sheet
C)Home; Format
D)Home; Share Workbook
2
When you ____ a workbook, you can keep users from inserting, deleting, and renaming worksheets in that workbook.
A)turn on Track Changes
B)merge a workbook
C)share a workbook
D)protect a workbook
3
You can use the Custom Lists dialog box to ____.
A)unlock a selected range of cells
B)insert a new worksheet into a workbook
C)apply a password to a workbook
D)merge two workbooks
4
What do the blue square around cells B3 and E4 mean?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L4Q4.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (64.0K)</a>
A)These cells are locked.
B)These cells are unlocked.
C)These cells were changed while Track Changes was turned on.
D)A reviewer has made suggested changes, which have been rejected.
5
To set a password to open a workbook, choose ____, click the ____ drop-down arrow, and click General Options.
A)Review; Protect Workbook
B)Review; Protect Sheet
C)Save As; Tools
D)Save As; Save as type
6
If you want edits to be marked as you make them, choose ____.
A)Review>Comments>Show All Comments
B)Review>Changes>Track Changes
C)Review>Changes>Show Ink
D)Review>Comments>New Comment
7
Excel passwords ____.
A)cannot prevent users from opening workbooks, but can prevent them from making changes
B)are case sensitive
C)are a type of digital signature
D)can contain only numbers
8
You can merge two workbooks if ____.
A)both have the same password
B)neither one contains any tracked changes
C)all of their cells are locked
D)both have been created from the same shared workbook
9
What does this Move or Copy dialog box tell you?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L4Q9.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (47.0K)</a>
A)That a copy of the selected sheet will be placed between sheets Week 1 and Week 2.
B)That a copy of the selected sheet will be placed between sheets Week 2 and Week 3.
C)That the selected sheet will be moved to between sheets Week 1 and Week 2.
D)That the selected sheet will be moved to between sheets Week 2 and Week 3.
10
To authenticate a workbook, ____.
A)protect a selected range of cells
B)protect the workbook
C)set a password to modify the workbook
D)use a digital signature
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe