excel中如何求制作一个学生成绩统计表。想要详细点的步骤。

假如Sheet1表中姓名和成绩的数据区域在A2:B10000,
A B C D E
1 姓名 成绩 总人数 任课教师 录入人
2 张三 54 李老师 王老师
3 李四 55
4 王五 66
5 张三 77
6 吴一

表Sheet2中的公式为：
总人数 =COUNTA(Sheet1!A2:A10000)
与考人数 =COUNT(Sheet1!B2:B10000)
与考率 =TEXT(COUNT(Sheet1!B2:B10000)/COUNTA(Sheet1!A2:A10000),"0%")
任课老师 =Sheet1!D2
录入人 =Sheet1!E2
60分以下 =COUNTIF(Sheet1!B2:B10000,"<60")
60-69.9 =COUNTIF(Sheet1!B2:B10000,"<70")-COUNTIF(Sheet1!B2:B10000,"<60")
70-79.9 =COUNTIF(Sheet1!B2:B10000,"<80")-COUNTIF(Sheet1!B2:B10000,"<70")
80-89.9 =COUNTIF(Sheet1!B2:B10000,"<90")-COUNTIF(Sheet1!B2:B10000,"<80")
90分以上 =COUNTIF(Sheet1!B2:B10000,">90")
平均分 =ROUND(AVERAGE(Sheet1!B2:B10000),1)
最高分 =MAX(Sheet1!B2:B10000)
最低分 =MIN(Sheet1!B2:B10000)
优秀率(>=90) =TEXT(COUNTIF(Sheet1!B2:B10000,">=90")/COUNT(Sheet1!B2:B10000),"0.0%")
优秀人数(>=90) =COUNTIF(Sheet1!B2:B10000,">=90")
及格率(>=60) =TEXT(COUNTIF(Sheet1!B2:B10000,">=60")/COUNT(Sheet1!B2:B10000),"0.0%")
及格人数(>=60) =COUNTIF(Sheet1!B2:B10000,">=60")
不及格率 =TEXT(COUNTIF(Sheet1!B2:B10000,"<60")/COUNT(Sheet1!B2:B10000),"0.0%")
不及格人数 =COUNTIF(Sheet1!B2:B10000,"<60")

描述太不清楚，你们学校的状况，对各个数据是怎么计算的，分几个班，每个数据要不要分班，什么信息都没有

ig
668