Solved

Microsoft Excel Dropdown Menu Creation

Posted on 2013-11-06
4
224 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
ID: 39628623
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
ID: 39629960
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
ID: 39630285
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
ID: 39644776
Thank you very much.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

733 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