Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.
A) SUM
B) AVERAGE
C) COUNT
D) MEDIAN

Question

Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.
A) SUM
B) AVERAGE
C) COUNT
D) MEDIAN

Quizplus · Accepted Answer

In order to determine the current student grade, Antoinette would have to use the AVERAGE function to calculate the average grade for the entire term. The SUM function would only add up the grades and not provide an average, while the COUNT function would only count the number of grades without calculating the average. The MEDIAN function would provide the middle value of a range of grades, but not necessarily the current grade status of each student.

Case 2-2 Antoinette Is Part of a College Department Creating a Number