Advanced Excel Formulas and Functions - Quiz

Quiz Question

1.	Which of the following is a cell reference?
		Relative
		Absolute
		Mixed
		All of the above
2.	An absolute address is defined with the use of this symbol:
		@
		%
		*
		$
3.	If the sheet name includes spaces, the sheet name must be enclosed in:
		Quotation marks
		Exclamation marks
		Asterisks
		Parenthesis
4.	A list is different from normal worksheet data because it ______________ have entire blank rows or columns
		Does
		Does not
5.	The DATA, SORT option is used if one wishes to sort _________ criteria
		One
		More than One
		Zero
6.	In the picture to the left, the line points towards the selection used to create a:
		Line
		Box
		Button
		Text
7.	Macros can be assigned to:
		An existing toolbar
		A new toolbar
		Any toolbar
		All of the above
8.	If using FALSE and an exact match is not found, then the following error will appear:
		#
		Unknown
		Error
		#NA
9.	A single IF statement ____________ be enough to give you the results you are looking for
		May
		May not
10.	The AND and OR functions can have up to _________ arguments.
		5
		10
		20
		30
11.	The NOT function has _________ argument
		1
		5
		10
		30
12.	In a spreadsheet, one can perform calculations using dates
		True
		False
13.	The ceiling function rounds a number:
		Up
		Down
14.	The floor function rounds a number:
		Up
		Down
15.	The TRUNC function truncates a number to the of the decimal point.
		Right
		Left
		Either direction