Home > Topics > excel > How to calculate average score in excel

How to calculate average score in excel

藏色散人
Release: 2020-02-28 09:42:31
Original
35456 people have browsed it

Excel’s method of calculating the total average score

Tool: excel2010 version.

1. Use the formula as shown below to calculate the total score and average score of all students in the table;

How to calculate average score in excel

2. First, enter the total score in cell E2 Enter the summation SUM function, =SUM(B2:D2), and press the enter key to get the result;

How to calculate average score in excel

3. Place the mouse in the lower right corner of cell E2 , the drop-down formula can be used to calculate the total score of all students;

How to calculate average score in excel

4. Then enter the average AVERAGE function in the average score cell F2, =AVERAGE( B2:D2), press the enter key to get the result;

How to calculate average score in excel

5. Place the mouse in the lower right corner of cell F2, and pull down the fill formula to calculate all The average score of the classmates.

How to calculate average score in excel

The above is the detailed content of How to calculate average score in excel. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template