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

Source: Internet
Author: User

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.