Site MapHelpFeedbackLesson 23 - Using Workgroup Features
Lesson 23 - Using Workgroup Features
(See related pages)

1
What is a change history?
A)List of all edits in a shared workbook
B)List of all users with a copy of a shared workbook
C)A sheet with each user's name and computer location
D)A sheet with intervals between times changes
2
What two tabs are included in the Share Workbook dialog box?
A)Advanced and Editing
B)Popular and Advanced
C)Track Changes and History
D)Editing and History
3
What group in the Share Workbook dialog box activates the change history?
A)Track changes
B)Update changes
C)Include in person view
D)Highlight which changes
4
Which two choices are available for handling conflicting changes in a shared workbook?
A)Changes from this user and Changes from that user
B)Allow changes and Do not save changes
C)When file is saved and Automatically every
D)Ask me which changes win and The changes being saved win
5
Where does the Compare and Merge Workbooks button appear?
A)View command tab
B)Review command tab
C)Quick Access toolbar
D)Microsoft Office toolbar
6
How can you display the Compare and Merge Workbooks button?
A)Open the Mini toolbar.
B)Open the Microsoft Office menu.
C)Right-click the Quick Access toolbar
D)Right-click the status bar
7
When the track changes command is active, how can you identify a cell that has been edited?
A)It is shaded and displays a comment.
B)It has a colored border and a small triangle marker.
C)It has a triangle marker and colored fill.
D)It is shown in a Filter list.
8
Which of these objects can be inserted in a shared workbook?
A)Comments
B)Charts
C)Shapes
D)Tables
9
What term describes a set of workers who share an Excel workbook?
A)Colleagues
B)Cooperatives
C)Workset
D)Workgroup
10
Which of these statements about a shared workbook is false?
A)A shared workbook can be accessed by multiple users simultaneously.
B)A shared workbook is usually located on a network drive.
C)A shared workbook can be copied.
D)A shared workbook has rows that cannot be deleted.





To learn more about the book this website supports, please visit its Information Center.
(c)2008 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


PASOnline Learning Center

Home > Excel > Lesson 23 Quiz