① Create a new workbook, enter the column headings in Sheet1, and enter the characters you want to examine
② set the correct answer area and hide
Enter or paste the following formula in the C2:
=lookup (CODE (A2), 45217+{ 0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{ "A", "B", "C", "D", "E", "F", "G", "H", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "W", "X", "Y", "Z"})
A2 is the cell in which the Chinese character "Hu" is to be examined. The meaning of this formula is to get the code of the Chinese character and convert it into English letters.
The formula screenshot is as follows:
③ Select the column and set the Hide.
Set score
In D2, enter =if (b2= "", "", if (b2=c2,10,0)), said if the correct answer to give 10 points, the wrong answer to 0 points, did not answer without scoring.
Form making