See if Dave Peterson's automated survey builder is something you can work with:
http://www.contextures.com/xlform01.html

(There is a download-able file there)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

I'm making a fruit and veg quiz in excel with multiple choice, and a
few true or false questions. I'm not a beginner to excel, but a
complete beginner to making quizzes with excel. I need somebody to help
me with some formulas or direct me to a wesbite that can give me a step
by step guide, as simple as possible.

id appreciate it alot. many thanks.