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;
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;
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;
4. Then enter the average AVERAGE function in the average score cell F2, =AVERAGE( B2:D2), press the enter key to get the result;
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.
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!