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.
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:
We can according to their actual business to flexible application.