NEW
Font size
WorksheetsIF Function - Excel
Total questions: 10
Worksheet time: 5mins
If function allows to choose between two actions based on whether the condition is true or ..................
false
1
Yes
-1
IF function makes use of something called
functional operators
logical
operators
logical
database
absolute reference
Which of the following is the correct formula for the IF function in Excel?
IF (criteria_testing, value_if_true, value_if_false)
=IF (criteria_testing, value_if_true, value_if_false)
=(criteria_testing, value_if_true, value_if_false)
The IF Statement takes a logical test and determines a result that is either True or False.
TRUE
FALSE
If the cell B2 is 68, what will this IF function give you as a result? =IF (B2>60, 'pass', 'fail')
pass
fail
60
How many parts are there to an IF statement/function?
2
3
4
1
=IF(B5>B4, "Large", "Small")
The value in B5 = 56
The value in B4 = 89
What is the result that this IF statement will return?
Large
Small
A2 = 20, B2 = 30, C2 =40
=IF(B2<>C2, A2*10,"")
What value should be returned if the statement is true?
20
300
200
400
A2 = 20, B2 = 30, C2 =40
=IF(B2<>C2, A2*10,"")
What value should be returned if the statement is false?
an empty cell
200
400
300
