Spreadsheet - IF Condition

What does the IF function do in a spreadsheet?

• Repeats the same value in all cells

• Checks a condition and returns one value if TRUE, another if FALSE

• Calculates the average of numbers

• Formats cells automatically

Which is the correct syntax for an IF function?

• =IF(test, true_value, false_value)

• =IF(true_value, false_value, test)

• =IF(test; true_value; false_value)

• =IF(true_value; test; false_value)

If cell A1 contains 80, what will =IF(A1>=50, "Pass", "Fail") return?

• Pass

• Fail

• 50

• 80

What will this formula return if A1=40? =IF(A18 and “Normal” if not?

• =IF(B1>8, "Overtime", "Normal")

• =IF("Overtime", B1>8, "Normal")

• =IF(B18, "Overtime")

If A1=70, what will =IF(A1>90, "Excellent", IF(A1>60, "Good", "Try Again")) return?

• Excellent

• Good

• Try Again

• 70

Which IF function will return “OK” if C1 equals 100, otherwise “Not OK”?

• =IF(C1=100, "OK", "Not OK")

• =IF("OK", C1=100, "Not OK")

• =IF(C1>100, "OK", "Not OK")

return if A1=74? a) Distinction b) Merit c) 74 d) Pass

• Distinction

• Merit

• 74

• Pass

Why might an IF formula return FALSE unexpectedly?

• Because the cell is locked

• Because the test condition is not met

• Because the function name is wrong

• Because the spreadsheet is too large