Computer Education for Teachers: Integrating Technology into Classroom Teaching, 4/e

Vicki Sharp, University of California - Northridge

Spreadsheets

Multiple Choice Quiz


1	The first integrated spreadsheet was
		A)	VisiCalc
		B)	Lotus 1-2-3
		C)	Excel


2	In Microsoft Excel, a cell is
		A)	Identified by its column letter and row number
		B)	Identified on a grid by x and y coordinates
		C)	Identified by a field marker


3	The letters across the top of a spreadsheet identify the
		A)	Cells
		B)	Columns
		C)	Rows


4	What type of information cannot be entered into a cell?
		A)	Text
		B)	Clip art
		C)	Numbers


5	A spreadsheet program appropriate for the third grade level is
		A)	AppleWorks
		B)	The Cruncher
		C)	Microsoft Works


6	The formula for taking the average of the numbers in cells B2 and B3 in Excel is
		A)	= AVERAGE(B2+B3)
		B)	= AVERAGE(B2+B3)/2
		C)	= AVERAGE(B2:B3)


7	A macro is a group of commands that are combined into one or two keystrokes.
		A)	True.
		B)	False.


8	What is not a consideration in choosing a spreadsheet program for the classroom?
		A)	Ease of use
		B)	Available fonts
		C)	Hardware compatibility


9	If you change a number in a spreadsheet, related formulas are automatically
		A)	Deleted
		B)	Recalculated
		C)	Hidden


10	A spreadsheet can be used for all of the following except
		A)	As a grade book and attendance chart
		B)	To convert numerical data into charts
		C)	To input graphics and clip art into 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.