WorksheetsExcel If function WSC 4.2.3
Total questions: 10
Worksheet time: 6mins
Choose the best description of the IF function
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
Returns TRUE if any of the conditions are true and returns FALSE if all conditions are false
Returns TRUE if all conditions are true and returns FALSE if any of the conditions are false
Returns a value from a list using a given position
We can use IF function in this example:
Calculating student grades. If the sum of points is greater than or equal to "35", then the formula returns "Pass", otherwise it returns "Not Pass".
True
False
Choose the correct format of the IF function:
=IF(logical test,value if true,value if false)
=IF(logical test,value if false,value if true)
=IF(value if true,value if false,logical test)
=IF(value if false,value if true,logical test)
Which is the correct way to write this function:
IF B4 is greater than 200, show "High", otherwise, show "Low"
IF(B4>200;"High";"Low")
=IF(B4<200,"High","Low")
=IF(B4>200,"High","Low")
=IF(B4>200"High","")
Which of these comparison operations means "Less than or equal to"?
<
<>
<=
$
Please type below the comparison operator that means "Not equal to"
(a)
Choose a formula where IF function is nested inside itself:
=IF("Function"=NESTED,"text A","text B")
=IF(C5>500,C5*20,0).
=IF(AVERAGE(B2:B10)>100,SUM(C2:G10),0)
=IF(A1=10, “text A”,IF(A1=20, “text B”, “text C”))
What should we type in the formula below instead of 0 if we want to show a blank cell instead of zero as a Value if False: =IF(A1>75,"A",0)
@
"x"
"No A"
" "
What would show in the cell after you hit enter if the value in G8 was 62?
I feel that I understand the IF function in Excel
I strongly agree
I agree somewhat
I strongly disagree
I disagree somewhat
I'm not sure
