Multiple Choice Quiz

Click on the correct response for each question below.

1		This Excel feature includes functions to calculate an Average, Minimum, Maximum, and Count.
			A)	A. Format
			B)	B. Number
			C)	C. AutoSum
			D)	D. Calculate
2		Excel is designed to provide visual cues to the relationships between the cells that provide values to the formulas or the cells that depend on the formulas by
			A)	A. Bolding the cell references to match the color coding of the borders around the referenced worksheet cells.
			B)	B. Highlighting the cell references.
			C)	C. Color coding the cell references in the formula to match the borders around the referenced worksheet cells.
			D)	D. Bolding the cell references.
3		To copy a cell, you would drag the cell border while simultaneously holding down the Ctrl key when
			A)	A. You have one or more cells to copy.
			B)	B. Only some of the cells are visible in the window.
			C)	C. You don’t want to refer to absolute references.
			D)	D. The distance between cells is short and they are both visible in the window.
4		The cell reference, $A$10 is a(n)
			A)	A. Relative reference.
			B)	B. Absolute reference.
			C)	C. Incorrect reference.
			D)	D. Mixed reference.
5		$C12 is a(n)
			A)	A. Relative reference.
			B)	B. Mixed reference.
			C)	C. Absolute reference.
			D)	D. Incorrect reference.
6		The cell reference, B4 is a(n)
			A)	A. Relative reference.
			B)	B. Incorrect reference.
			C)	C. Mixed reference.
			D)	D. Absolute reference.
7		A cell reference can be changed to absolute or mixed by using this key.
			A)	A. F1
			B)	B. F2
			C)	C. F3
			D)	D. F4
8		To use the ABS key, your program must be in this mode and the cell reference that you want to change must be selected.
			A)	A. Insert
			B)	B. Edit
			C)	C. Formula
			D)	D. Reference
9		You can use this menu command to copy a sheet into a new sheet in a workbook.
			A)	A. Tools/Copy Sheet
			B)	B. Insert/Move Sheet
			C)	C. Edit/Move or Copy Sheet
			D)	D. Format/Copy or Move Sheet
10		Each sheet in a workbook should be assigned one of these to help identify the contents of the sheet.
			A)	A. Identifying style
			B)	B. Tab
			C)	C. Descriptive name
			D)	D. Chart color
11		A sheet name can be up to
			A)	A. 15 characters.
			B)	B. 31 characters.
			C)	C. 57 characters.
			D)	D. 84 characters.