Student Resources: Lesson Quizzes

Lesson 5: Using Simple Formulas and Functions

	1.	What type of formula can be used to determine percentages, averages, and individual prices, for example?

		a.	Addition
		b.	Division
		c.	Multiplication
		d.	Subtraction

	2.	You can apply the Percent Style by clicking the Percent Style button on the __________ toolbar.

		a.	Standard
		b.	Formatting
		c.	Control Toolbox
		d.	External Data

	3.	Math hierarchy is another term for order of precedence.

		a.	TRUE
		b.	FALSE

	4.	An argument defines the necessary parts of the function and the order of those parts.

		a.	TRUE
		b.	FALSE

	5.	What function calculates the arithmetic mean of a range of cells?

		a.	AVERAGE
		b.	COUNT
		c.	COUNTA
		d.	SUM