How does excel calculate the total score, average score, pass rate and excellent rate?

In teaching, EXCEL is often used to count students' grades, including the number of people who passed the exam and the passing rate. If these functions are all operated in one menu, it will be more complicated. In fact, you can directly enter the functions in the table and get them easily. Here, I will share with you how excel calculates the total score, average score, pass rate and excellent rate.

0 1 Open the excel sample document to edit. Knowing the results of four students, we need to calculate the total score, average score, pass rate and excellent rate.

First of all, let's sum up our choices, okay? Formula? Column, select the automatic summation function under the formula to get the total score.

In the same way, click the average function command under the formula and continue to get the second average.

Now, let's demonstrate the specific operation process: select the data area, click Find and Average in the corresponding box, and press Enter after confirmation.

05 to get the sum and average of the three values in this column.

06 calculation method of passing rate: in the box corresponding to the passing rate, enter COUNTIF(B2:B7, "> = 60 ")/count (B2: B7), where 60 or more means that the failing score is 60.

07 calculation method of excellent rate: input function =COUNTIF(B2:B5, "& gt=90")/COUNT(B2:B5). It should be noted that all functions need to be used at the beginning? =? No, so be sure to write.

As shown in the figure, it is as simple as calculating the total score, average score, pass rate and excellent rate with excel.