Student Resources: Lesson Quizzes

Lesson 7: Using Advanced Functions and Hyperlinks

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

		a.	TRUE
		b.	FALSE

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

		a.	Logical
		b.	Multiple
		c.	Nested
		d.	Serial

	3.	What Text function does Excel use to convert text to title case?

		a.	INT
		b.	PROPER
		c.	ROUND
		d.	UPPER

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

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

	5.	When you save an Excel file in a different format, the filename is the same but the workbook will have a different filename extension.

		a.	TRUE
		b.	FALSE