How can I create a template for checking the audio order of a WPS table?

1. Create a workbook, enter the titles of each column in sheet1, and enter the Chinese characters you want to examine.

2. Set the correct answer area and hide it.

Enter or paste the following formula in the C2 format:

= LOOKUP (CODE (A2), 45217 + {9264, 544,1101, 1609,1793, 2080,2560, 2902,3845, 20177,4679, expires, 5405,5689, 6170,6229, 7001,7481, expires }, {"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 where the Chinese character "hu" is located. The meaning of this formula is to get the Chinese character code and convert it into English letters.

Select this column to hide it.

3. Set the score.

Enter = IF (B2 = "", "", IF (B2 = C2, 10, 0) in the D2 lattice, which indicates that IF the correct answer is received, 10 points will be given and 0 points will be given, if you do not answer the question, no score is obtained.

Use the SUM function in the B12 lattice to obtain the total score.