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:

Culturally Responsible

Being aware of and respectful toward the cultural differences and similarities among individuals, including understanding how these cultural aspects influence behaviors, attitudes, and opportunities.

Sexual Orientation

An enduring pattern of emotional, romantic, or sexual attractions to men, women, or both sexes.

Communication Styles

The various ways in which individuals express themselves and interpret messages from others, influenced by cultural, personal, and situational factors.

Conflict Resolution

The process of resolving disagreements or disputes through effective communication, negotiation, or other methods to achieve a peaceful solution.