WPS Form 2013 make sequencer Test score questionnaire

① start WPS Form 2013, first enter the topic, as well as some information.

② in the C2 cell, enter the function formula: =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"}) To get the code for the Chinese character and convert it to an English letter.

③ press ENTER, get the correct sequencer H.

④ fills other cells with a cell drop-down fill.

⑤ then enter the judgment function in the D2 cell: =if (b2= "", "", if (b2=c2,10,0)), said that if the correct answer to give 10 points, the wrong answer to 0 points, did not answer without scoring.

⑥ fills this function intact, and finally we can test it.