Student Resources: Lesson Quizzes

Lesson 11: Working with Range Names

	1.	Excel requires that you begin a name range with a letter.

		a.	TRUE
		b.	FALSE

	2.	A value used in a formula that does not change is called a

		a.	Cell address.
		b.	Constant.
		c.	Function.
		d.	Range.

	3.	To name a constant, you use the __________ dialog box.

		a.	Create Names
		b.	Define Name
		c.	Paste Name
		d.	Format Cells

	4.	The VLOOKUP function scans the lookup table by row.

		a.	TRUE
		b.	FALSE

	5.	What function displays row data in a column or column data in a row?

		a.	HYPERLINK
		b.	INDEX
		c.	TRANSPOSE
		d.	ROWS