A fast random-call operation method for examination room in Excel

today small series for everyone to share in the examination room in Excel quick random call operation method, operation is very simple, the following small series for everyone to introduce a detailed, not friends can refer to, to see.

　　Steps

First, open Excel to enter the names of the candidates entered the form, as shown in the following picture:

Then unify all selected candidates ' names, as shown in the following figure:

Then select the random Pull button in random repetition, as shown in the following figure;

In the dialog box that pops up, place the cell empty, tick, and click OK, as shown in the following figure:

The selection box for the output area is then ejected, and we select the active cell as shown in the following image:

When you click OK, we will find that the two dog in the original data area has been changed to the cell K1, as shown in the following figure:

Continue to call the next candidate's name, repeat the above operation, you can call Liu Hua sister to do the answer, as shown in the following picture:

　　Attention matters

We can according to their actual business to flexible application.