Lesson 19 - Exploring List Ranges


1	How many outline levels are possible in Excel?
	A)	2
	B)	4
	C)	6
	D)	8



2	To copy the results of an advanced filter to another location, what must you create first?
	A)	Setup range
	B)	Output range
	C)	Range name
	D)	Wildcard range



3	What term describes a single piece of data in a list range?
	A)	Field
	B)	Field name
	C)	Field record
	D)	Field value



4	Which option from the Filter arrows allows you to sort by the fill color?
	A)	AutoFill Sort
	B)	AutoFilter Sort
	C)	Sort by Cell Color
	D)	Sort by Shading



5	What results in an Address field if the criteria is str?
	A)	Records in which the last name is Streeter or Listron
	B)	Records in which the address includes the word Street
	C)	Records that include str in any field
	D)	Records that str in the header row



6	Which of the following criteria uses a valid wildcard character?
	A)	ch@
	B)	ch*
	C)	ch^
	D)	ch%



7	Which text string would find records that include the word Road in the address?
	A)	rd
	B)	road
	C)	rod
	D)	road



8	Which function category includes DCOUNT and DAVERAGE?
	A)	Database
	B)	Logical
	C)	Math & Trig
	D)	Statistical



9	Which of the following functions is a database function?
	A)	DSUM
	B)	DGLAZE
	C)	DPART
	D)	DGROUP



10	Besides being in place, where might the results of an advanced filter be placed?
	A)	Criteria range
	B)	List range
	C)	Named range
	D)	Output range

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Home > Excel > Lesson 19 Quiz