Workshop: Design a multiple-choice quiz in Excel

Who said spreadsheets are boring? Discover how to have some fun and develop your skills at the same time

Written by Nick Peers, Computeractive

You might think that Excel is all about number-crunching and little else. Well think again.

In this Workshop we’re going to explore how to have fun with Microsoft’s popular spreadsheet tool.

We’re going to demonstrate how to make a multiple-choice quiz whereby a player has to select the correct answer from a dropdown menu.

Advertisement

At the end of the quiz they will be shown their overall score and given a rating based on how well they’ve done.

This Workshop requires basic knowledge of Excel. The screenshots are from Excel 2007, but the tutorial will work in 2000, 2002 (XP) and 2003. As the instructions can differ between versions we’ve included alternative directions.

Here's how to create a multiple-choice quiz in Excel.

Tags:

Reader comments

More from Computeractive

News

The latest home computing news

Downloads

The best PC tools, applications and more

Reviews

Independent opinions on new hardware and software

Step-by-step guides

Easy-to-follow projects with pictures

PC Help

Solve PC problems with our Q&A

Videos

PC projects demonstrated and product reviews

Articles

An in-depth look at how to get the best from your PC

Magazine

What's coming up in Computeractive

Forums

Get help with your PC problems from our readers

Competitions

Your chance to win computing prizes

Shopping

Great deals on products, services and more

NEW! Computeractive CD Rom 11
All 26 issues of Computeractive from 2008 on one CD-Rom.

Ultimate Guide to Disc Burning
Everything you need to know about creating your own discs.

Create your own calendars softwareCreate your own Calendars
The fun and easy way to create your own calendars!

Computeractive - Issue 280Computeractive Back Issues
Missed an issue? Click here to find a back issue

Blogs

Windows Watch

Windows Watch

Keeping an eye on the latest XP and Vista news

Outlook 2007 email controversy

One of the major changes in Outlook 2007 had nothing to do with the Ribbon but that Word was used to display...

Download Junkie

Download Junkie

Your daily dose of download discussion

Backup important data with SyncBack SE

Keeping certain files backed up helps to keep items safe in case anything disastrous happens to your computer, but although most of...

Advertisement

Free email newsletters

Techno babble demystified...

[Display all definitions]

Or type in any computer-related word and click "Go"

Advertisement

Computeractive is not reponsible for content of Google adverts

Primary Navigation

© Incisive Media Ltd. 2009. Incisive Media Limited, Haymarket House, 28-29 Haymarket, London SW1Y 4RX, is a company registered in England and Wales with company registration number 04038503

Search computeractive.co.uk