Choose the best answer

1.			Which of the following is not a characteristic of a list in spreadsheet software?
			A)	Each column has only one type of information
			B)	The first row in the list contains the labels or column headings
			C)	The list does not contain any blank rows
			D)	None of the above
2.			Which of the following is a function you can use to help make a decision?
			A)	AutoFilter
			B)	Conditional formatting
			C)	Pivot table
			D)	All of the above
3.			Which of the following helps you quickly aggregate or summarize information by dimension?
			A)	AutoFilter
			B)	Conditional formatting
			C)	Pivot table
			D)	All of the above
4.			Which of the following maintains the view of the entire list of information but highlights key pieces of information that you may be looking for?
			A)	AutoFilter
			B)	Conditional formatting
			C)	Pivot table
			D)	All of the above
5.			Which of the following helps you quickly create a view of partial lists of information?
			A)	AutoFilter
			B)	Conditional formatting
			C)	Pivot table
			D)	All of the above
6.			Which function would you use if you wanted to scroll through an entire list of customers and have all purchases greater than $10 highlighted?
			A)	AutoFilter function
			B)	Custom AutoFilter function
			C)	Pivot table
			D)	Conditional formatting
7.			What can you use more than one of when using the AutoFilter function?
			A)	Column
			B)	Row
			C)	Table
			D)	None of the above
8.			What is the intersection of a row and a column?
			A)	Cell
			B)	Database
			C)	Autoformat
			D)	All of the above
9.			What is a collection of information arranged in columns and rows where each column displays one type of information is called?
			A)	Pivot table
			B)	Hierarchical database
			C)	List
			D)	Spreadsheet
10.			Which of the following do you need to have before you can use a pivot table?
			A)	Spreadsheet
			B)	List
			C)	Filter
			D)	Table