Student Resources: Lesson Quizzes

Lesson 14: Using Auditing Tools

	1.	What error value message means the formula uses the wrong type of argument or operand?

		a.	#N/A
		b.	#NULL!
		c.	#REF!
		d.	#VALUE!

	2.	What button on the Formula Auditing toolbar traces the source of a formula’s result?

		a.	Error Checking
		b.	Trace Dependents
		c.	Trace Error
		d.	Trace Precedents

	3.	A precedent is a cell that “depends” or relies on another cell.

		a.	TRUE
		b.	FALSE

	4.	You can display the Formula Auditing toolbar by choosing View, Toolbars, Customize.

		a.	TRUE
		b.	FALSE

	5.	What option in the Go To Special dialog box selects all cells that support the active cell?

		a.	Current array
		b.	Data validation
		c.	Dependents
		d.	Precedents