Using WPS form to make Sequencer search Word method Test template

The elementary school Chinese examination, often tests uses the sequencer to search the word method to look up the dictionary. It is impossible for a student to actually look up a dictionary in the actual exam, usually to ask the student to write the first letter of the specified Chinese character. In order to improve the students ' correct answer rate, we can make a sequencer test template to strengthen training, interested language teachers or parents can try. Open your wps form and try it now!

First, create a new workbook, enter the column headings in the Sheet1 , and enter the characters you want to examine.

Second, 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 to set the hidden.

Third, set the 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.


The SUM function is used to find the total score in the B12 lattice.

Form making