40 students scored in excel.

1. Open Excel and create a new table.

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.

What are the teaching models advocated in compulsory education and ordinary high school mathematics curriculum standards?

How does math diary write 300 words about the final exam in Grade Four?

Is Lubking cheap? Who does he like? (He is from Class One and Class Two, High School Attached to Peking University)

Dreaming about doing papers.

How to study in senior one?

What is a high-quality math class like?

How to inquire about the registration results of Mingde Primary School in Yucheng County?

Is the placement exam difficult?

How to cultivate students' innovative ability in primary school mathematics teaching

The "Lanchester Combat Model" in mathematical modeling is expected to be explained in detail by experts! !