Multiple Choice Quiz

Click on the correct response for each question below.


1	When creating a macro using the Visual Basic Editor, this window is used to write, display and edit the macro statements or code.
		A)	Format
		B)	Edit
		C)	Code
		D)	Tools


2	In Excel, this is used to quickly calculate multiple what-if versions in one operation and to view the results of all variations together in a worksheet.
		A)	Scenario
		B)	Solver
		C)	Argument
		D)	Data table


3	This will appear as a note box attached to a cell in a form.
		A)	Comment
		B)	Reference
		C)	Link
		D)	Name


4	When creating a one-variable data table, the formula is entered in the column to the left of the first value and one cell below the row of values if the input values are listed
		A)	across the column.
		B)	down the column.
		C)	down the row.
		D)	across the row.


5	Which of the following is not a logical operator?
		A)	<=
		B)	%
		C)	=
		D)	AND


6	In Excel, this is a built-in combination of formats that can be applied to a range of cells.
		A)	Field
		B)	Autoformat
		C)	Chart
		D)	Table


7	A range name cannot begin with
		A)	a letter.
		B)	an underline.
		C)	a backslash.
		D)	a number.


8	This is the item that the statement will affect in a macro.
		A)	Procedure
		B)	Property
		C)	Object
		D)	Reference


9	Which of the following is not one of the security level options for macros?
		A)	High
		B)	Neutral
		C)	Low
		D)	Medium


10	This code window contains the recorded macro statements for all settings that are on by default in the page setup dialog box.
		A)	Format
		B)	Visual Basic
		C)	Edit
		D)	Insert


11	The controls on this toolbar are for use with existing Excel macros and work best on worksheets that will be used only in Excel.
		A)	Format
		B)	Controls
		C)	Objects
		D)	Forms

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.