Multiple Choice Quiz

Click on the correct response for each question below.


1	When reviewing a workbook, this can be set up to allow multiple users to make changes to the workbook at the same time.
		A)	Linked workbook
		B)	Shared workbook
		C)	Data workbook
		D)	Listed workbook


2	When you receive a reviewers’ comments, the easiest way to review them is to
		A)	save the reviewed copy and delete the original.
		B)	open both copies in a window.
		C)	merge the reviewed copy with the original.
		D)	overwrite the original in a temporary folder.


3	Changes made in this type of workbook are maintained in a separate History worksheet.
		A)	Merged
		B)	Linked
		C)	Temporary
		D)	Shared


4	When viewing changes in a shared workbook, this is displayed directly on the worksheet using onscreen highlighting.
		A)	Change history
		B)	Reviewer comments
		C)	Errors
		D)	Changes


5	When using multiple reviewers, each reviewer’s changes are identified in the workbook by a different
		A)	color.
		B)	font.
		C)	number.
		D)	name.


6	To isolate specific changes in a worksheet you can use these, which are located next to the column labels.
		A)	Reference arrows
		B)	Filter arrows
		C)	Destination arrows
		D)	Format arrows


7	This converts external data that have been saved in another format into a format that can be used by Excel.
		A)	Exploding
		B)	Filtering
		C)	Importing
		D)	Exporting


8	This saves data in another format so that it can be used in an application other than the application in which it was created.
		A)	Exploding
		B)	Filtering
		C)	Importing
		D)	Exporting


9	In Excel, the menu command to analyze a list is
		A)	Tools//Filter/AutoFilter.
		B)	Data/Filter/AutoFilter.
		C)	Edit/Filter/AutoFilter.
		D)	Format/Filter/AutoFilter.

2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.