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:

Business Forms

Various legal structures that businesses can take, such as sole proprietorships, partnerships, corporations, and limited liability companies (LLCs), each with different legal and financial implications.

Incorporation Options

Various legal structures available for setting up and registering a company, each with different regulatory, tax, and liability implications.

Malpractice

Professional misconduct or lack of skill that results in harm to another, common in medical, legal, and financial services professions.

Partnership

A form of business legally established for joint operation, where management duties and profits are shared among two or more collaborators.