摘要
学校每次考试后,对年级各班级成绩进行分析、统计,工作量较大且比较繁琐。为了方便快捷地处理学生成绩,文章介绍了Excel的数组公式和SUM函数。灵活运用SUM函数和数组公式,在不调整原始数据顺序的情况下,实现了多工作表的学生成绩分析与统计,为成绩统计提高了效率,保证了统计数据的可靠性。
The analysis and statistics of students'score about each class of grade is relatively cumbersome after examination.In order to deal with students’score conveniently,this paper introduces Excel's array formula and SUM function.Without adjusting the order of original datum,students'score analysis and statistics in multi-sheet is achieved by using flexibly SUM function and array formula.These ensure the reliability of statistical data and improve the efficiency about statistics of students'score.
作者
杨建
丁亚军
YANG Jian;DING Ya-jun(The Nineteenth Middle School of Changsha,Changsha 410006,China;The Department of Computer Education, Hunan Normal University,Changsha 410006,China)
出处
《电脑与信息技术》
2017年第2期35-37,共3页
Computer and Information Technology
基金
湖南省教育厅教改项目(项目编号:湘教通2015-291)
