Excel IF and IF nested Functions/Formulas

In Excel, what does the IF function allow you to do?

• Perform calculations
• Make conditional decisions
• Create charts
• Sort data

What is the basic syntax of the IF function in Excel?

• IF(logical_test,value_if_true,value_if_false)
• IF(logical_condition,value_if_true,value_if_false)
• IF(condition,then_value,else_value)
• IF(test,do_this,otherwise_do_that)

If you want to check if a cell A1 is greater than 10 in Excel, which formula would you use?

• =IF(A1>10,"Yes","No")
• =IF(A1<10,"Yes","No")
• =IF(A1=10,"Yes","No")
• =IF(A1>=10,"Yes","No")

What does the value_if_false argument in the IF function represent?

• The action if the condition is true
• The action if the condition is false
• The logical test
• The cell reference to check

In Excel, if you want to nest multiple IF functions, what is the maximum number of IF functions you can nest?

• 5
• 10
• 15
• 20

How can you express "If A1 is equal to B1 and B1 is equal to C1, then 'Yes'" using the IF function in Excel?

• =IF(A1=B1=C1,"Yes","No")
• =IF(A1=B1 AND B1=C1,"Yes","No")
• =IF(A1=B1, B1=C1, "Yes","No")
• =IF(A1=B1,"Yes",IF(B1=C1,"Yes","No"))

What is the purpose of the "value_if_true" argument in the IF function?

• It specifies what to do if the condition is true
• It specifies what to do if the condition is false
• It specifies the logical test
• It specifies the cell to check

If you want to check if a cell A1 is both greater than 10 and less than 20 in Excel, which formula would you use?

• =IF(AND(A1>10,A1<20),"Yes","No")
• =IF(OR(A1>10,A1<20),"Yes","No")
• =IF(A1>10,"Yes",IF(A1<20,"Yes","No"))
• =IF(A1>10+A1<20,"Yes","No")

n Excel, what does the following formula do? =IF(A1>10, "Pass", "Fail")

• Checks if cell A1 contains the text "Pass"
• Adds the values in cell A1 and A10
• Checks if the value in cell A1 is greater than 10
• Displays the current date
• None of the above

You want to create a formula in Excel to display "Yes" if the value in cell B2 is greater than 50, and "No" otherwise. What would the formula be?

• =IF(B2 > 50, "Yes", "No")
• =IF(B2 = 50, "Yes", "No")
• =IF(B2 < 50, "Yes", "No")
• =IF(B2 >= 50, "Yes", "No")
• =IF(B2 <= 50, "Yes", "No")