How can I create a question bank with an RNG

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top