Click on the correct response for each question below.

1		This specifies the values, cells, or expressions that a function uses as input to compute its final value.
			A)	Cell range
			B)	Categories
			C)	Symbols
			D)	Arguments
2		This is the general form of a function.
			A)	function-name (argument list)
			B)	argument list (function name)
			C)	argument name (function list)
			D)	function-list (argument name)
3		This generates a random number from an internal calculation without the need for an argument value.
			A)	NOW
			B)	RAND
			C)	ROM
			D)	RAM
4		This is not a level of Error Alert available in the Data Validation dialog box.
			A)	Stop
			B)	Correction
			C)	Information
			D)	Warning
5		This is used to either define a name or to go to a named cell or cell range.
			A)	Range box
			B)	Name box
			C)	Cell box
			D)	Function box
6		This is the correct form of the IF function.
			A)	= IF (conditional test, expression if true, expression if false)
			B)	IF ( condition if true, condition if false, expression)
			C)	= IF ( condition if true, condition if false, expression)
			D)	IF (conditional test, expression if true, expression if false)
7		The second and third arguments of the IF function can be constants or
			A)	absolute expressions.
			B)	arbitrarily complex expressions.
			C)	relative expressions.
			D)	fixed expressions.
8		This is not one of the text boxes that represents the IF function's arguments.
			A)	Value_If_False
			B)	Value_If_True
			C)	Absolute Reference
			D)	Logical Test
9		This is not one of the values used to calculate the PMT function.
			A)	Number of loan payments
			B)	Loan duration
			C)	Loan amount
			D)	Periodic interest rate
10		Loan repayments are an example of
			A)	fixed payments.
			B)	absolute payments.
			C)	balanced payments.
			D)	periodic payments.
11		A function is preceded by an equal sign, followed by the function name and an open parenthesis.
			A)	True
			B)	False
12		THE RAND function receives its input from the computer's clock.
			A)	True
			B)	False
13		Most functions do not have any particular number of arguments or arrangement of arguments.
			A)	True
			B)	False
14		Cell names can be referenced and used in a formula, replacing the need to make the cell absolute.
			A)	True
			B)	False
15		When defining a name in one worksheet, it is not available to all worksheets in the workbook.
			A)	True
			B)	False
16		The IF function can display only character string expressions.
			A)	True
			B)	False
17		For the lookup functions HLOOKUP or VLOOKUP to work properly, the vertical table must be sorted in descending order on the values in the first column.
			A)	True
			B)	False
18		Only the first argument of the four in the PPMT function changes when creating a series of these formulas in a loan amortization schedule.
			A)	True
			B)	False
19		The NOW function is the most commonly used date function.
			A)	True
			B)	False
20		If you type =NOW in a cell, Excel will generate and display an error message rather than a date.
			A)	True
			B)	False