【摘要】 为了解决手工录入成绩费时又易错位的问题,通过使用VLOOKUP函数将模考成绩快速搜索并写入汇总统计表功能,然后利用INDEX函数、MATCH函数和MAX三个函数结合实时查找最高分人的姓名,并使用COUNTIF函数实时统计及格人数和及格率等,经实验测试实现了快速搜索并写入数据,实时查找和统计功能,最后对模拟实验后成绩提取和生成进行了探讨。更多还原

【Abstract】 In order to solve the problem of time-consuming and misplacement when manually entering the score, we use the VLOOKUP function to quickly search and write the summary test score, and then use the INDEX function, the MATCH function and the MAX function to find the highest score in real time, and use the COUNTIF function to calculate the number of people who pass and the pass rate in real time. Through the experimental test, the fast search and write data, real-time search and statistics function are realized. Finally, we discuss the the score extraction and generation after the simulation experiment.更多还原