Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
What function should be used to assign grades based on the given range?
What function should be used to assign grades based on the given range?
- COUNTIF function
- SUM function
- IF function (correct)
- VLOOKUP function
Which function should be employed to calculate the average grade for the 20 students?
Which function should be employed to calculate the average grade for the 20 students?
- AVERAGE function (correct)
- VLOOKUP function
- COUNTA function
- SUMIF function
Which function is suitable for counting the number of students who received an A grade?
Which function is suitable for counting the number of students who received an A grade?
- COUNTIF function (correct)
- SUMIF function
- IF function
- VLOOKUP function
