考场的随机排座及动态演示

Random Seating Arrangement in the Examination Room and Dynamic Demonstration

当给定了考生的学号、姓名等信息之后,如何快速地将一个考场内考生的座位随机安排？这是一个很有实用价值的问题。本文灵活运用了Excel中的多个函数的组合,巧妙地解决了考场的随机排座和考生座位的查找问题,并用实例进行动态演示说明。

How to quickly arrange the seats of examinees in an exam room when given the information of the students＇ number,name and so forth？ This is a very practical problem. This paper uses the combination of several functions in Excel flexibly, which perfectly solves the problem of random arrangement and finding of examinee seats, and uses examples to demonstrate and illustrate.