Simple clear advice in plain English

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

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.

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.

Article tags

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Making an electronic form

Use Microsoft Word to create all types of electronic forms

We show you the best way to create an electronic form within a Word document

Word's undo feature

How to fix common PC errors

It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors

Great software giveaway illustration

Discover 30 free software programs

Sound too good to be true? We've found some programs that are so good we're amazed there is no price tag. We cast our eye over 30 of the best

Question & Answer

Q.Why are some of the keys on my keyboard doing strange...

> Read the answer

Q.Is my phone’s Bluetooth any use?

> Read the answer

Q.Can I switch boot drives so that I can work on older...

> Read the answer

Best deals on the web

img

Samsung RV520-A07

£356.50- Buy it now

img

Acer Aspire 5750G (LX.RXP02.019)

£399.99- Buy it now

img

Apple MacBook Pro (MD313B/A)

£904.37- Buy it now

Latest issue & subscription deals

Poll

Are you concerned about viruses that target mobile phones?

Jargon Buster

Computing terms explained in plain English

CAD

Computer Aided Design. Software used to create 3D models.

Great shopping deals from Computeractive