VBA Based Automatic Evaluation System for Excel Operation Competence Test
Yu‐Ju Liu
Abstract
Yu‐Ju Liu
Abstract
This paper analyzes the features of Excel software,and sums up some knowledge items of Excel operation competence tests,of which an automatic evaluation algorithm is implemented with VBA is proposed,together with a realistic example of automatic evaluating Excel document.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
This paper analyzes the features of Excel software,and sums up some knowledge items of Excel operation competence tests,of which an automatic evaluation algorithm is implemented with VBA is proposed,together with a realistic example of automatic evaluating Excel document.
Key concepts: Visual Basic for Applications, Computer science, Ms excel, Software, Competence (human resources), Software engineering, Data mining, Programming language