The Score of Five Students in a Subject Are Inserted

question 16

Multiple Choice

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100,B: 80 to 89,C: 70 to 79,D: 60 to 69,and F: 0 to 59.Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?

• A) =IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A"))))
• B) =IF(B2<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89,"B","A"))))
• C) =IF(B2
• D) =IF(B2=0-59,"F",IF(B2=60-69,"D",IF(B2=70-79,"C",IF(B2=80-89,"B",IF(B2=90-100,"A"))))

---

Definitions:

Child

A young human being below the age of puberty or below the legal age of majority.

Theory Of Mind

The ability to attribute mental states—beliefs, intents, desires, emotions, knowledge—to oneself and others, understanding that others have beliefs, desires, and intentions that are different from one's own.

Infer

To deduce or conclude information from evidence and reasoning rather than from explicit statements.

Intentions

Refers to plans or goals that individuals aim to achieve through their actions or behaviors.