Excel random roll call table creation operation content

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.

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.

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!