How to make lottery applet with Excel? The method of making lottery applet with Excel

Excel excellent course recommends zero-based introduction to Excel tables, and quickly master the skills of Excel- worksheet office automation. Excel- spreadsheet function practical course Excel- spreadsheet pivot table Excel- spreadsheet chart drawing course The use of office software is a very basic skill, which can help people to do word processing, table making, data processing, making speeches and so on quickly. Office software has a wide range of applications, from statistics to records, digital office and so on. In order to help users quickly master the use of office software, excellent teaching courses are conducted with office software such as Word, Excel, PPT and mind map. You can try it for free, and friends who don't have office software must not miss it.

The method of making lottery applet with Excel;

1, open the prepared form, which needs a name.

2. Then, merge the cells on the right, make tonight lucky and fill it in black, and merge the cells below and fill it in red.

3. Then enter the randbetween function in the red area and set the first behavior 2 and the last behavior 7.

4. Then enter the previous Index function. The first two lines of index refer to columns.

5. Finally, after the reference is completed, add a bracket, and then click OK. You can see that the system will automatically fill in a person's name.

6. Then press enter to start, and the names of candidates will appear randomly.

This is how Excel demonstrates how to make a lottery applet. Excel is a popular data processing software for personal computers, which has functions such as tables, charts, functions and databases. If you want to teach yourself Excel, you must visit Yutu.