Multiple Choice
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 C2 to check whether the student has passed or failed?
A) '=IF(B2>=60, "Pass", "Fail")
B) =IF(B2 < 60, "Pass", "Fail")
C) =IF(B2 = 60, "Pass", "Fail")
D) =IFERROR(IF((B2 >= 60, "Pass", "Fail") )
Correct Answer:

Verified
Correct Answer:
Verified
Q10: Helen wants to resize slicer buttons to
Q127: After adding data validation criteria to a
Q128: Which of the following is an effect
Q129: What information do you need to provide
Q130: The COUNTIF function counts blank cells.
Q133: Angie created a PivotTable that includes two
Q134: When you right-click a cell containing a
Q135: Charlie imported data that displays "Albany, NY"
Q136: To display a duplicate of a chart
Q137: Which of the following is not a