Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Excel Dropdown Menu Creation

Posted on 2013-11-06
4
Medium Priority
?
238 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

609 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