Question

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C_2 to check whether the student has passed or failed?

a. IF(B2>=60, "Pass", "Fail")
b. CHECKPASS(B2, 60)
c. PASSFAIL(B2, 60)
d. EVALUATE(B2, 60)

Answer 1

To check whether a student has passed or failed based on their score, use the IF function. The correct function to use in cell C2 is IF(B2>=60, "Pass", "Fail").

Step-by-step explanation:

To check whether a student has passed or failed based on their score, you can use the IF function in Excel.

The correct function to use in cell C2 would be IF(B2>=60, "Pass", "Fail").

This function checks whether the score in cell B2 is greater than or equal to 60. If it is, it returns "Pass". If it's not, it returns "Fail".

For example, if a student scored 66 on the third exam, the function would return "Pass" because 66 is greater than or equal to 60.