Excel IF and Nested IF Functions Quiz

What does the IF function do in Excel?

• Calculates totals

• Checks a condition and returns one value if true and another if false

• Sorts data

• Applies formatting

The IF function can also be used with ________ values, such as TRUE and FALSE.

Which of the following is the correct syntax for the IF function?

• =IF(condition, value_if_true, value_if_false)

• =IF(value_if_true, condition, value_if_false)

• =IF(value_if_false, condition, value_if_true)

• =IF(value_if_true, value_if_false, condition)

If the formula =IF(A1>10, "Yes", "No") is used in cell B1 and the value in A1 is 8, what will B1 display?

• Yes

• No

• Error

• True

Which of the following formulas represents a correct nested IF statement?

• =IF(A1>10, "High", IF(A1>5, "Medium", "Low"))

• =IF(A1>10, IF(A1>5, "Medium", "Low"), "High"," "), " "

• =IF(A1>10, "High", IF("Medium", A1>5, "Low"))

• =IF(A1>10, "High", "Medium", "Low")

The limitation for the maximum number of nested IF levels in Excel 2007 and newer versions is ________.

In the formula =IF(A1="Passed", "Congratulations", IF(A1="Failed", "Try Again", "Invalid")), what is displayed if A1 contains "Incomplete"?

• Congratulations

• Try Again

• Invalid

• Error

Which of the following best describes the limitation of nested IF functions in older versions of Excel (pre-Excel 2007)?

• Cannot handle text values

• Maximum of 7 levels of nesting

• Only works with numbers

• Does not allow calculations inside conditions

What is the output of =IF(A1>10, "Above 10", IF(A1>5, "Between 6 and 10", "5 or below")) if A1 contains the value 6?

• Above 10

• Between 6 and 10

• 5 or below

• Error

Nested IF statements are used when more than ________ condition needs to be evaluated. (type the number)