【摘要】 学校每次考试后,对年级各班级成绩进行分析、统计,工作量较大且比较繁琐。为了方便快捷地处理学生成绩,文章介绍了Excel的数组公式和SUM函数。灵活运用SUM函数和数组公式,在不调整原始数据顺序的情况下,实现了多工作表的学生成绩分析与统计,为成绩统计提高了效率,保证了统计数据的可靠性。更多还原

【Abstract】 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.更多还原