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

Question

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

Quizplus · Accepted Answer

The correct function is using nested IF statements with the logical operators "<" to check if the score falls within a certain range. A score from 0 to 59 should return an "F", a score from 60 to 69 should return a "D", a score from 70 to 79 should return a "C", a score from 80 to 89 should return a "B", and a score from 90 to 100 should return an "A". Choice A correctly follows this logic and uses the correct symbols for the logical operators. The other choices have errors in their syntax, such as using "

The Score of Five Students in a Subject Are Inserted