2. Enter the header in the first line, such as student's name, Chinese score, math score, English score, total score, average score, etc.
3. Enter student information and grade data line by line in the second line.
4. Use the SUM function in the Total Score column to find the total score of each student. The formula is "=SUM(B2:D2)", and it is assumed that Chinese scores, math scores and English scores are in columns B, C and D respectively.
5. Use the AVERAGE function in the Average column to find the average score of each student, and the formula is "=AVERAGE(B2:D2)".
6. Using the "Sort" function in the "Data" tab, you can sort the total score and average score of 40 students.