Multiple Choice
The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60.Which of these functions will you insert in C2 cell to check if the student has passed or failed?
A) =IF(B2>=60,"Pass","Fail")
B) =OR(B2>=60,"Pass","Fail")
C) =AND(B2>=60,"Pass","Fail")
D) =NOT(OR((B2>=60,"Pass","Fail") )
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Which of the following formulas can you
Q3: A student wants to round the number
Q4: Jose inserts the formula '=DATE('2000,2,2)' in cell
Q5: The formula =ROUNDDOWN(G5,0)can be used to round
Q6: To extract the seconds from the time
Q8: To round time 10:30 pm inserted in
Q9: You've copied a cell containing formula to
Q10: Ian needs to extract the day from
Q11: In which of the following boxes under
Q12: Nathan wants TRUE to be elicited if