巧用数据透视表统计计算机等级考试成绩

Use Skillfully to the Computer Grade Examination Results with Pivot Table Statistics

本文讨论了用Excel数据透视表统计计算机等级考试一级MS-Office成绩的两种方法。两种方法均能非常方便快捷的完成对考试成绩的统计分析,充分体现了数据透视表的强大的数据处理能力,以及其使用的便捷性。

This article discussed the use of Excel pivot table statistics level 1 MS-Office computer grade examination results of two methods. Two methods all can very conveniently perform a statistical analysis of test scores, fully embodies the powerful data processing ability of the Pivot Table, as well as its ease of use.