Please answer this question ASAP. & provide the correct function to use.

In Chapter 20 & 21 we learned the functions COUNTIF and AVERAGEIF in class. Using the data and solutions in the Q2 tab of this workbook, determine the following: (10 points) How many students received the following grades? Grade #of students A A- B+ B B- C+ C- D+ D F What was the average test score for each of the following grades? average score Grade A A- B+ B B- C+ C C- D+ D F # of students # of students scoring below 60 In Chapter 20 & 21 we learned the functions COUNTIF and AVERAGEIF in class. Using the data and solutions in the Q2 tab of this workbook, determine the following: (10 points) How many students received the following grades? Grade #of students A A- B+ B B- C+ C- D+ D F What was the average test score for each of the following grades? average score Grade A A- B+ B B- C+ C C- D+ D F # of students # of students scoring below 60