Question

how to make a mcq question paper in excel​

Answer 1

Answer:

$\huge\boxed{\fcolorbox{blue}{orange}{Answer}}$

_____________________________________________

STEP 1: CREATING THE WORKSHEETS

Open Excel. Make sure you save the file as .xls (office 2003 format) as in the office 2007 and above formats the macros is not saved properly.

Create 2 worksheets named "Querstions" and "Testing Questions"

In the Questions worksheet create or copy the questions that you want to be asked, with the correct answers ofcourse.

In the cell H1 put the formula =COUNTA(G:G) (this will keep track of the questions marked to be asked)

In the cell I1 put the formula =COUNTA(A:A) (this will keep track of total number of questions)

STEP 2: CREATING USER FORM

Open VBA and create a user form.

Put 7 controls as shown in the image.

Create proper names for the controls (final file is attached)

STEP 3: WRITE THE CODE

*Create a macro for the Button on the worksheet

STEP 4: EXECUTE THE CODE

Click the start test button. The user form should open and the options with the questions should be populated. If it does not open, that means your macro settings are not set. Kindly google for the same.

STEP 5: HOW DOES IT WORK

1. First 10 questions are marked at random.

2. The user form is opened and the first question is put to the user.

3. When the user selects an answer the Next button is enabled.

4. When the next button is clicked the code compares the right answer with the user's answer and if it is OK the score bar is increased.

5. This happens till all the 10 marked questions have been answered.

${\huge{\sf{\blue{\underline {\underline {⚠ƒοℓℓοω ↯}}}}}}$