The specific operation steps are as follows:

1. Open EXCEL and click the cell for which you want to calculate the total score. (The figure below is only the demonstration data, and the ranking is based on the total score of personal language and mathematics. )

2. Enter the formula =SUM(B2:C2) in the D2 cell.

3. Pull down D2 cells and fill in D4 cells.

4. Click the E2 cell.

5. Enter the formula =RANK(D2, $D$2:$D$4) in the E2 cell.

6. Just pull down the E2 cell and fill it in the E4 cell.