Using WPS form to make electronic word dictation

The office of MM is fanatical Korean family, not only hit the Korean dramas each episode must see, the popular Korean music is regarded as a treasure. Even more call Chith unexpectedly made several Korean friends on the net. Language does not become a major barrier to communication, Kazakhstan and Korea mm determined to learn Korean. In order to test the effect of learning, mm as soon as there is time to write down words, but manual control is very troublesome. Then asked me if I can do an electronic word from memory, I after research, and finally use WPS form to create an electronic word dictation, right and wrong automatic judgment. The specific action is this:

First, open the WPS form, establish a new form, in A1, B1, C1, D1 in turn, enter the word, "meaning", "dictation", "judgment."

Second, enter the Korean word in column A, and enter the corresponding Chinese meaning in column B.

Enter the formula "=if" (EXACT (A2,C2), "correct", "error") in D2, and drag the fill handle down to copy the formula.

Select column A and hide column A by using the "column → hide" command under the Format menu.

At this point, the word dictation is basically done (Figure 1). But there are two points that are not perfect:

Figure 1

1, c as a blank, that is, there is no dictation, but also to judge. You can change the formula in D2 to "=if" (ISBLANK (C2), "Please write", IF (EXACT (A2,C2), "correct", "error") ", so that no dictation will prompt" please write. "

2, the judgment is not eye-catching, the habit of mistakes are shown in red.

You can use conditional formatting under the Format menu to display errors in red, select column D, click Conditional Formatting under the Format menu, and do the following in the Conditional Formatting dialog box (Figure 2).

Figure 2

Such a perfect electronic word from memory to create a successful (Figure 3), need to add words, cancel a column hide Add.

Figure 2

Formula Explanation: The EXACT function is a string comparison function that tests whether two strings are identical.  Returns TRUE if they are identical, otherwise, returns FALSE. The ISBLANK function is to determine whether a cell is blank.　The formula "=if" (EXACT (A2,C2), "correct", "error") means "correct" if the contents of A2 and C2 are identical, or "error" is displayed. Formula =if (ISBLANK (C2), "write", if (EXACT (A2,C2), "correct", "error") "Plus whether it is a blank cell, and if C2 is blank, show" Write please. "