How can I create a question bank with an RNG

[Guest]

How can I create a question bank with an (RNG) Random Number Generator that
will select a fixed number of questions for creating exam papers in either
Excel or Access?

 

[Alex Delamain]

One simple method is as follows
List all your possible questions (or a unique reference number) i
column A.
In column B enter =Rand() and copy it down to all the rows.
Then sort the data on column B (either ascending od descending - i
makes no difference) and starting at row 1 pick as many questions a
you need.
Every time you sort the data it will give a different sequence
selectio