Asked by Kathryn Murphy on May 16, 2024
Verified
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") )
Cell B2
A specific cell located in column B and row 2 of a spreadsheet, used to reference a particular data point.
Passing Score
The minimum score required on a test or examination to be considered successful or to achieve a certain certification or qualification.
- Understand the theory and practical use of conditional formatting and calculations.
Verified Answer
GS
Gurdeep SinghMay 20, 2024
Final Answer :
A
Explanation :
The IF function with the logical test B2>=60 checks whether the score in cell B2 is greater than or equal to 60. If it is, the function returns "Pass", otherwise it returns "Fail".
Learning Objectives
- Understand the theory and practical use of conditional formatting and calculations.
Related questions
Jason Wants to Display the Text Poor If the Value ...
In a Form,how You Can Highlight the CustomerType Text Box ...
Conditional Formatting Can Change the Appearance of a Report Control ...
Which of the Following Conditional Formats Can You Apply to ...
You Can Create Conditional Cell Formats Using Either the Home ...