M5 L2 Quiz

Which of the following are not evaluated in the MAX or MIN functions? Select all that apply.

• Cells with number values

• Ranges with number values

• Empty cells

• Text values in the specified range

You need to determine the largest value in a range of numbers. Which function should you use?

• SUM

• MIN

• COUNT

• MAX

A(n) _______________ is a predefined formula used for specific purposes and calculations.

• Date

• Table

• Function

The COUNT function will not count negative numbers when evaluating a range of values. True or false?

• True

• False

A cell that contains zero (0) is evaluated as a blank cell. True or False?

• True

• False

The COUNTBLANK function counts the following value types: (Select all that apply)

• Numeric constants

• Numeric cell ranges

• Empty text strings

• Empty cells

The _______________ function counts all the numeric values in a specified range.

• COUNT

• COUNTA

• COUNTBLANK

An IF function can contain additional calculations as arguments. True or False?

• True

• False

Consider the following formula: =IF(C20>=25,C20*5,). What happens to a false result if you remove the last comma in the IF statement?

• 0 is displayed

• FALSE is displayed

• Error is displayed

• C20*5 is displayed

Describe what happens with the following IF statement; =IF(C20>=25,C20*5,)

• If C20 is less than or equal to 25, then multiply C20 by 5, otherwise display a 0

• If C20 is greater than or equal to 25, then multiply C20 by 5, otherwise display a 0

• If C20 is greater than or equal to 25, then add C20 by 5, otherwise display a 0

• If C20 is less than or equal to 25, then add C20 by 5, otherwise display a 0