Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Microsoft Excel Dropdown Menu Creation

Posted on 2013-11-06
4
Medium Priority
?
242 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 2000 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

572 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