Student Center | Instructor Center | Information Center | Home

Office XP Excel 2002, 2/e

Timothy O'Leary, Arizona State University

Using Solver, Creating Workbook Templates, Linking Workbooks, and Creating Scenarios

Multiple Choice Quiz

Click on the correct response for each question below.


1	In Excel, this can be displayed when making changes to a worksheet to see the effect of those changes.
		A)	Formula window
		B)	Function window
		C)	Watch window
		D)	Tools window


2	This feature can simplify the entering of functions in a worksheet by prompting you to select a function from a list.
		A)	Insert Function
		B)	Format Function
		C)	Style Function
		D)	Field Function


3	The cells that you select in Solver must be related through this on the worksheet.
		A)	Fields
		B)	Links
		C)	Formulas
		D)	Tables


4	In the Edit Scenario dialog box, this text box displays the text “Created by [name] on [date].
		A)	Statistics
		B)	Summary
		C)	Comment
		D)	Custom


5	Which of the following is useful in any application where input and output are required using the same format?
		A)	Designs
		B)	Templates
		C)	Scenarios
		D)	Workbooks


6	In Excel, this is designed to help forecast the outcome of various possible actions in a worksheet.
		A)	Scenario
		B)	Link
		C)	Reference
		D)	Field


7	An Excel workbook template is saved with a special file format with this file extension.
		A)	.xls.
		B)	.xtf.
		C)	.xst.
		D)	.xlt.


8	Which of the following is not one of the options available in the Paste portion of the Paste Special dialog box?
		A)	Values
		B)	Cells
		C)	Formats
		D)	Formulas


9	When linking workbooks, Excel uses this reference in the external reference formula.
		A)	Mixed
		B)	Fixed
		C)	Absolute
		D)	Linked


10	This is the cell in Solver that is set to the value that you want to be attained.
		A)	Adjustable
		B)	Target
		C)	Field
		D)	Operator


11	To unlock cells in a worksheet, select the Protection tab in this dialog box.
		A)	Insert Protection
		B)	Format Cells
		C)	Protect Cells
		D)	Lock Cells

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.