The Score of Five Students in a Subject Are Inserted

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(B2D) =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") ) ) )