基于Excel多功能统计表的设计与实现  

Design and Implementation of Excel Multifunctional Statistical Table

作　　者：李艳[1] 徐运武[1] LI Yan;XU Yun-wu(College of Guangdong Songshan Polytechnic,Shaoguan 512126,China)

机构地区：[1]广东松山职业技术学院

出　　处：《电脑知识与技术》2019年第12期204-205,209,共3页Computer Knowledge and Technology

基　　金：广东省教育厅资助项目(粤教高函[2012]54号-A12)

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

关 键 词：函数 快速 搜索 写入 实时 统计 

分 类 号：TP399[自动化与计算机技术—计算机应用技术]