Student Resources: Lesson Quizzes

Lesson 5: Using Simple Formulas and Functions

	1.	Templates are automatically saved with a filename extension of

		a.	.dat
		b.	.tmp
		c.	.xls
		d.	.xlt

	2.	You can convert a percent to its decimal equivalent by dividing the percent amount by 100.

		a.	TRUE
		b.	FALSE

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

		a.	Standard
		b.	Formatting
		c.	Forms
		d.	PivotTable

	4.	A syntax is usually one or more values or cell ranges that a function needs to complete its calculation.

		a.	TRUE
		b.	FALSE

	5.	The __________ function tallies the number of values in a range.

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