Solved

Microsoft Excel Dropdown Menu Creation

Posted on 2013-11-06
4
219 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best way to convert ePub file to doc or docx file 11 181
Data-Updating-VBA-V3 15 46
Outlook 365 8 68
Creating a tuition video for users 2 89
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
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 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 …

803 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