Excel worksheet format

What answer does the landlord want? Is it the method and steps of operation? Or should I send you the operation required by the form?

1 Select A 1: H9 cell area, and click the center symbol and border symbol on the toolbar above.

Select the cell area of A 1: H 1, click fill, and then select yellow.

2 apply the summation formula in the cell corresponding to the total score, the symbol is horizontal m, and the average score formula is applied to the average score. Add up.

3 apply IF function. Details are difficult to express.

There is a worksheet name in the lower left corner. Right-click and rename the chart. Select the information of the top three students and click the menu to insert the chart.