Student Resources: Lesson Quizzes

Lesson 6: Using Logical and Financial Functions

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

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

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

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

	3.	Excel inserts an automatic page break when a worksheet is too wide or too tall to fit on the default paper size for your printer.

		a.	TRUE
		b.	FALSE

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

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

	5.	The Accounting style shows negative numbers in

		a.	Bold
		b.	Brackets
		c.	Parentheses
		d.	Quotes