Using WPS form to make Sequencer search Word method Test template

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.