Solved

Microsoft Excel Dropdown Menu Creation

Posted on 2013-11-06
4
207 Views
Last Modified: 2013-11-13
I've created several multiple choice questions in excel. Each question has a dropdown menu with 4 choices each.

Is there a way I can set this up so when a user selects the wrong answer they are alerted?

Is there a way I can set this up so points are accrued for each correct answer?
0
Comment
Question by:Lord_Dragon
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:helpfinder
Comment Utility
I did not get nothing "profi" so I created just simple and if nothing maybe it will be better than nothing :)
Correct answer could be highlighted with green background, wrong by red (unfortunately manual work for each answer). Each correct answer could have points which can be counted by formula
sample.xlsx
0
 

Author Comment

by:Lord_Dragon
Comment Utility
Thank you but I need more detail on how to set this up. For example, what would I do to have correct answers give a green background and incorrect answers give a red background?
0
 
LVL 19

Accepted Solution

by:
helpfinder earned 500 total points
Comment Utility
This red/green background is made by conditional formatting (check it on Home ribbon in excel) where you tell what is right answer (green) and what not (red).
In B column is formula (IF) which validate the answer - if it is correct (true) than it gives certain amount of points, if not (false) it gives nothing (or less, as you desire).
Because B column formula contains right answer I make this column hidden (better will be to lock worksheet to prevent user unhide it). Finally in C column is just a refference to B to show points.
Overall score is simple Sum of points

Just ask if you need anything else
0
 

Author Closing Comment

by:Lord_Dragon
Comment Utility
Thank you very much.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now