Question

question 6
what is the logical_test in the formula =if(a2>60,\pass\,\fail\)?
□ if(a2>60)
□ \pass\
□ \fail\
□ a2>60

Explanation:

The IF function in Excel has the syntax =IF(logical_test, value_if_true, value_if_false). In the formula =IF(A2>60,"Pass","Fail"), the logical_test is the part that evaluates to true or false, which is A2>60. "Pass" is the value if true, "Fail" is the value if false, and IF(A2>60) is not the correct form of the logical test here.

Answer:

D. A2>60