How can I create a question bank with an RNG

B

Brewmeister

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top