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"))))

Know the best practices for protecting personal information when posting résumés online.

Master the creation and importance of a professional elevator speech.

Acknowledge the importance of action verbs in highlighting qualifications on a résumé.

Understand the use and formatting of plain-text résumés for electronic applications.

---

Definitions:

Inconsistent Tense

Refers to the misuse of verb forms within a sentence or paragraph, impairing readability and clarity.

Taking Bus

The act of using bus public transportation for travel from one location to another.

Welcome Home Party

A celebratory gathering held to welcome someone back home after a significant absence.

Weighed Pounds

A measurement of body weight or mass in pounds (lbs).