First, open the Excel2003 software, create a blank Excel table, and enter the students' grades in the table.
How to sort grades in excel tables
Then, select all the sorted information contents, including students' names, subjects, total scores, etc. , and select all the students' grades.
How to sort grades in excel tables
Then click data, and the first item in the drop-down menu is sorting. Click Sort.
How to sort grades in excel tables
Then the sorting function box appears, because the total score is sorted, so the main keyword must select the total score. Click on the small black triangle, you can drag the scroll bar down to find the total score, then set the secondary keyword and choose the name. The third keyword is unnecessary. You can choose Chinese, math or English. Select all in descending order on the right, and then click OK.
How to sort grades in excel tables
How to sort grades in excel tables
You will find that the students' grades have been sorted according to the total score, with the highest score of 273 ranking first and the lowest score of 2 14.
How to sort grades in excel tables
end
Single series classification:
Single subject sorting and total score sorting are the same. First, select the names and subject scores of the students to be sorted.
How to sort grades in excel tables
Then click data, click sort, and set the main keywords for sorting. If Chinese scores are sorted, you can select Chinese in the column of main keywords. Select name as the second keyword and none as the third keyword. Finally, click OK.
How to sort grades in excel tables
How to sort grades in excel tables
You will see that Chinese scores are ranked from high to low, with the highest score of 82 and the lowest score of 6 1 point.
How to sort grades in excel tables
Summary of operation methods:
1. Enter the score in a blank table in Excel.
2. Select all the information to sort.
3. Click the data, and then click Sort to select the first keyword and the second keyword.
4. Select ascending or descending order, and then click OK.