Home  >  Article  >  Software Tutorial  >  Excel random roll call table creation operation content

Excel random roll call table creation operation content

WBOY
WBOYforward
2024-04-17 14:22:051223browse

How to use Excel to create a random roll call table? PHP editor Yuzai brings you an operation guide for making a random roll call table in Excel. By understanding the principles, production steps and precautions of a random roll call table, he can easily help you solve the roll call problem and improve the efficiency of classroom interaction.

List all the names in a table and create a table as shown in the picture.

Excel random roll call table creation operation content

Enter the function in the roll call box:

=INDIRECT("a"&RANDBETWEEN(3,12))

This RANDBETWEEN(3,12 ) means randomly selecting 3 to 12, and merging an A in front of it means A3 to A12, which corresponds to the cells of all the names in the name column. Putting an INDIRECT on the outside means that the contents of cells A3 to A12 are randomly selected.

Excel random roll call table creation operation content

After filling in, press Enter, then click F9 to draw randomly, or hold down F9 to simulate the lottery scene.

The above is the detailed content of Excel random roll call table creation operation content. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete