Based on excel and macro designing standardization self-test system

This paper focuses on the standardization self-test system design based on excel and macro. Because excel is a software of most people familiar and easy-to-use. And the function is very strong. The system can use function of function, cell cite, macros in excel to add amount of question database, modify score, arbitrary extraction test from question database, give a mark to result etc. This system can be as students learning self-test system arbitrary course.