Student Resources: Lesson Quizzes

Lesson 6: Using Logical and Financial Functions

	1.	A formula with a logical function, except for the __________ function, shows the word “TRUE” or “FALSE” as a result.

		a.	IF
		b.	AND
		c.	OR
		d.	NOT

	2.	What does the relational operator, <>, describe?

		a.	Equal to
		b.	Not equal to
		c.	Greater than or equal to
		d.	Less than or equal to

	3.	The default style for new data keyed in a new workbook is

		a.	Comma
		b.	Currency
		c.	Normal
		d.	Percent

	4.	An annuity is a series of equal payments made at regular intervals for a specified period of time.

		a.	TRUE
		b.	FALSE

	5.	What argument specifies whether payments are made at the beginning or the end of the period?

		a.	FV
		b.	Nper
		c.	Type
		d.	Rate