Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
hey guys...i badly need to make a quiz using excel,,,i got no clue how to do
it. the quiz will be a simple one, no drop downs and should display the scores after the quiz is taken.... please help! |
#2
![]() |
|||
|
|||
![]() Andruu, What type of quiz are you looking to create? What format are the answers? Numbers? Text? One suggestion..... 1. Add questions *What is 2 x 2?* 2. Assign cells for the user to insert their answers. (format cells as text/numbers etc) *Cell: B2* 3. Either in hidden cells, or on a seperate sheet, put the correct answers 4. Assign a point value for each correct answer (can be different for each question) 5. Compare the user's answer to the correct answer, if correct, add the value to the total. 6. At the end of the quiz, add a button to calculate score...and then print score. -- Pulcue ------------------------------------------------------------------------ Pulcue's Profile: http://www.excelforum.com/member.php...o&userid=24654 View this thread: http://www.excelforum.com/showthread...hreadid=382345 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a macro, that references another excel file ??? | Excel Worksheet Functions | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
how do I create qif files from Excel for import into Quicken? | Excel Discussion (Misc queries) |