Tabulate Multiple Choice Questions In A Database Using Excel Code

How to create MCQ or Multiple choice question answer sheet for students or other online exam? Is any VBA data base code to enter for creating this form or any PHP query for random MCQS within a database? I personally examine in many online testing site, which create this form “click-base” for example;

ProjectManagerClub.co.uk is all about?

  • Fashion
  • Project Management And Excel Details
  • Medical Study
  • Gaming Store

So in excel how I tick the “2” option? How to easily create this database like other excel different template like “Gantt Chart” “Dashboard template” or other?

Creating MCQS Database of Excel

Creating Code of MCQ in Database of Excel

First of all make sure what kind of excel version you are using (2003, 2007, 2010, 2012), actually some versions create data base with different code. Where to get Answer (Excel worksheet or Form)?

You can easily dome with this simple trick of excel, do you knows about “COUNTIF function” of excel and set keyboard for default chart ==> Alt + F1.

Authenticated Source for Solving this Question

Using this form you of MrExcel you can easily find out answer without trouble so much. Make sure these keys are different in different excel versions, but no problem with 2003, 2007 and 2010 version.

Cas Dave

Leave a Reply

Your email address will not be published. Required fields are marked *