Excel If function WSC 4.2.3

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"

• " "

In this IF function example:  =IF(G8>40,"Yes","No")
What would show in the cell after you hit enter if the value in G8 was 62?

• Yes
• No
• Nothing would show

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