Design Objective Questions Test Using Excel

Excel has powerful functions,so we can use these functions to design various data analysis tools.In this paper,starting from the actual application,the author analyzed how to design the objectivity test,in order to realize the automatic collection of the answers,and conduct the judgment of the test papers.