学生成绩统计表Excel豪华版(含图含公式)

姓名学号性别语文数学英语物理总分平均分最高分学生A111女8993849035689.0093学生B112男8887789835187.7598学生C117女8391858934887.0091学生D114女9790708934686.5097学生E116男9199698134085.0099学生F122女9080837632982.2590学生G113男8192886232380.7592学生H123女7080808431478.5084学生I125男8391746531378.2591学生J118女7969837830977.2583学生K120男9270776029974.7592学生L115男7686597429573.7586学生M121男6984717129573.7584学生N119男8579725729373.2585学生O124男8573666929373.2585总计125812641139114348041201.00平均值####################320.2780.07部分学生成绩表2030405060708090100成绩学生成绩表0102030姓名020406080100成绩姓名平均分每个人英语比例表23.6%22.2%25.2%27.2%25.5%23.6%26.9%25.8%20.0%24.1%24.6%22.5%每个人英语比例表最低分名次英语比例成绩情况84123.6%#NAME?78222.2%#NAME?83324.4%#NAME?70420.2%#NAME?69520.3%#NAME?76625.2%#NAME?62727.2%#NAME?70825.5%#NAME?65923.6%#NAME?691026.9%#NAME?601125.8%#NAME?591220.0%#NAME?691324.1%#NAME?571424.6%#NAME?661522.5%#NAME?部分学生成绩表学生成绩表语文数学英语物理物理平均分每个人英语比例表学生A22.2%24.4%20.2%20.3%25.2%27.2%每个人英语比例表学生A学生B学生C学生D学生E学生F学生G学生H学生I学生J学生K学生L学生M学生N学生O