How to rank students' grades with excel

1. First, open the excel table and click the cell you want to edit.

2. Click the formula in the menu bar-"Insert Function".

3. Enter "Grade". AVG ",and then click OK.

4. The window for setting function parameters pops up, and we enter B2 in the numerical value.

5. Enter $B$2:$B$ 17 in the reference.

6. Enter 0 in the ranking method.

7. Click OK to get the relevant ranking, as shown below, with the same score, showing its average ranking.

Public function

1, database function

When you need to analyze whether the values in the data list meet certain conditions, you can use the database worksheet function.

2. Date and time function

Date and time functions can be used to analyze and process date and time values in formulas.

3. Engineering function

The engineering worksheet function is used for engineering analysis. Most of these functions can be divided into three types: functions for dealing with complex numbers, functions for numerical conversion between different digital systems (such as decimal, hexadecimal, octal and binary), and functions for numerical conversion in different measurement systems.