NEW
Font size
WorksheetsSpreadsheet - IF Condition
Total questions: 8
Worksheet time: 4mins
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
