Student Resources: Lesson Quizzes

Lesson 7: Using Advanced Functions and Hyperlinks

	1.	UPPER and PROPER are the names of two of Excel’s Text functions.

		a.	TRUE
		b.	FALSE

	2.	You can add a hyperlink to your worksheet by pressing

		a.	Alt + K
		b.	Ctrl + H
		c.	Ctrl + K
		d.	Ctrl + Shift + K

	3.	The ROUND function shows only the non-decimal portion of a number.

		a.	TRUE
		b.	FALSE

	4.	Excel uses a serial number system to calculate dates and times.

		a.	TRUE
		b.	FALSE

	5.	A function inside another function is called a __________ function.

		a.	Nested
		b.	ROUND
		c.	SUM
		d.	Text