Student Resources: Lesson Quizzes

Lesson 10: Working with Multiple Worksheets and Lists

	1.	You can press __________ to move between open workbooks.

		a.	Ctrl + Alt + F6
		b.	Ctrl + F6
		c.	F6
		d.	Shift + F6

	2.	What term refers to a table of information with a row of headers followed by rows of data?

		a.	Formula
		b.	Filter
		c.	List
		d.	View

	3.	One requirement Excel has for using the various List commands effectively is that you must name a list as a range.

		a.	TRUE
		b.	FALSE

	4.	What gives you the ability to filter by more than one item and to use operators such as “greater than”?

		a.	3-D Reference
		b.	COUNTA function
		c.	Custom AutoFilter
		d.	Wildcards

	5.	A live link is a simple formula that refers to a cell.

		a.	TRUE
		b.	FALSE