The specific operation steps of using the IF function formula of OFFICE are as follows:

1. Open OFFICE and prepare a worksheet with complete data.

2. Click the elevation of the first cell.

3. Select the student number, and then click the Insert Function button.

4. Insert function option pops up, and select whether to function.

5. Click OK and enter the grade classification rules in the function parameter box.

6. Average score

Input G2

7. Click OK and hold down Fill to fill the remaining cells.