WPS table How to make a performance notice

WPS forms the method of producing the performance notice:

Select the "Score sheet" A1, tap Insert name, define, and then enter information as shown in Figure 3: Enter "name" (without quotes) in the name of the current workbook, and enter "=offset ($A $1,1,0,counta (A:A)-1,)" at the reference location. Formula meaning: Returns the number of students by CountA (A:A)-1, minus 1 is because the number of nonblank cells in column A contains the first row of "name"; then use the offset function to extract all the student names in column A.

Enter the notice cell A4, click on "Data" "effectivity" "Settings", where the validity conditions allow the selection of the conditions for the sequence, the source input "= name", while ensuring that the right "provide a drop-down arrow" before the tick (see Figure 4), determine after the Click cell I4 test Results.

Set data validation

Effectiveness of the establishment of the cell dropdown dish

Create a blank format to call the data in the score sheet.

Establish a basic format for a notification form

A. Select cell C2 and enter the following formula:

=vlookup (I4, score sheet!) a2:d1000,4,0) & "&I4&" Students ' results notice list "

B. Select cell D4, enter formula: =I4

C. Select cell F4 and enter the following formula:

=vlookup (I4, score sheet!) a2:c1000,3,0)

D. Select cell H4 and enter the following formula:

=vlookup (I4, score sheet!) a2:b1000,2,0)

E. Select cell F5 and enter the following formula:

=vlookup (i$4, score sheet!) A$2:k$1000,row (A5), 0)

F. Select cell F5 to pull the formula down to F11

At this point the formula is finished, you can select the I4 under the arrow to select different student names, you can see the "notice" of the data has followed changes. Subsequent printing will be printed by the Drop-down box to print any student's results at any time, without destroying the format of the original results table.