Question

Jim uses the following table to store the test scores of six new students who joined his class recently. He wants to use a formula that will indicate whether the students have cleared the test or not. The students can clear the test if they score more than 60. Which formula should Jim use?


Picture of the table and answers attached!

Thank you!!

Answer 1

Answer:

B.

Explanation:

IF(C3 > 60; "pass"; "fail") means if the value of C3 is greater than 60, then return pass, otherwise (that is, C3 is less than or equal to 60) return fail. With this formula, you can indicate whether the students have cleared the test or not.