Use a custom sorting method to add primary and secondary conditions for sorting. The operation steps are as follows:

Required materials: Excel.

First, select the "Average Score" column and enter the "Start Tab".

2. Click Sort and Filter, and then click Custom Sort in the drop-down menu.

3. Check "Expand the selected area" and click "Sort".

4. After opening the custom sorting window, click Add Condition.

5. With "average score" as the main keyword and "mathematics" as the secondary keyword, click "OK".

Six, the final effect is as follows. The cells A6, A7, A 10, A 1 1 are sorted by average. When the average score is the same, the math scores are sorted in ascending order.