Student Resources: Lesson Quizzes

Lesson 10: Working with Multiple Worksheets and Lists

	1.	A formula that refers to cells in another worksheet is described as a 3-D reference.

		a.	TRUE
		b.	FALSE

	2.	To start Extend Selection mode, press

		a.	F8
		b.	Alt + F8
		c.	Shift + F8
		d.	Shift + Alt + F8

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

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

	4.	A descending sort arranges rows in reverse alphabetical order or highest value to lowest.

		a.	TRUE
		b.	FALSE

	5.	You can create custom views by choosing Custom Views from the __________ menu.

		a.	Data
		b.	View
		c.	Insert
		d.	Format