Excel IF Function Quiz

What does the IF function do in Excel?

• Adds up a range of numbers

• Compares values and returns a result based on a condition

• Counts the number of cells in a range

• Finds the maximum value in a dataset

What is the correct syntax for the IF function?

• =IF(test, value_if_true, value_if_false)

• =IF(logical_test, result_if_true, result_if_false)

• =IF(condition, true_result, false_result)

• =IF(expression, if_true, if_false)

In the formula `=IF(A1 > 50, "Pass", "Fail")`, what will be the result if cell A1 contains 45?

• Pass

• Fail

• True

• Error

Which of the following is a common use of the IF function?

• Summing up a range of cells

• Returning a grade based on a score

• Formatting text to bold

• Changing the color of a cell

True or False: The IF function can only handle one condition at a time.

• True

• False

What would the formula `=IF(B1 = "Yes", "Approved", "Not Approved")` return if cell B1 contains "No"?

• Yes

• Approved

• Not Approved

• Error

In Excel, what would the formula `=IF(C2 >= 75, "Pass", "Fail")` return if C2 contains 80?

• Pass

• Fail

• True

• Error

Which of these formulas correctly checks if a value in cell D5 is less than 100, returning "Low" if true and "High" if false?

• `=IF(D5 < 100, "Low", "High")`

• `=IF(D5 = 100, "Low", "High")`

• `=IF(D5 > 100, "Low", "High")`

• `=IF(D5 <= 100, "Low", "High")`

In the formula `=IF(A1 > 100, "Above", IF(A1 < 50, "Below", "Between"))`, what is the purpose of nesting IF functions?

• To simplify the function

• To allow multiple conditions

• To improve accuracy

• To make the formula longer

Which of the following formulas would return “Valid” if cell E3 contains 1, and “Invalid” if it contains any other number?

• `=IF(E3 = 1, "Valid", "Invalid")`

• `=IF(E3 > 1, "Valid", "Invalid")`

• `=IF(E3 < 1, "Valid", "Invalid")`

• `=IF(E3 <= 1, "Valid", "Invalid")`