5 Questions
What function should be typed in the blank to calculate the class average for Test 1 and have it in cell G13?
=AVERAGE(B2:B30)
Which function sums the values in the range B2 to B30 and then divides by the count of values to calculate an average?
=SUM(B2:B30)/COUNT(B2:B30)
Which function would give the middle value in the range B2 to B30 when arranged in ascending order?
=MEDIAN(B2:B30)
What function calculates the difference between the maximum and minimum values in the range B2 to B30?
=MAX(B2:B30)-MIN(B2:B30)
If you want to quickly find the arithmetic mean of values in cells B2 to B30, which function should you use?
=AVERAGE(B2:B30)
This quiz requires you to type in the complete function to calculate the class average for Test 1 and have it in cell G13. You need to fill in the blank with the appropriate function in Excel.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
