Quiz in Excel

Quiz in Excel 2007
Creating a quiz in Excel is fun and easy. First you prepare your questions. Next using the data validation feature you link the answers to a cell. Using condtional formatting you can change the color of the cell and the data to indicate that the answer is correct. If the answer is correct, you can assign ‘1’ to the correct answer and ‘0’ to the wrong answer using the ‘IF’ function. Also the points can be summed using the SUM function. The question and answers of the quiz are reproduced below:

(1)Who was the first prime minister of India?
Gulzari Lal Nanda
Jawaharlal Nehru
Gandhi
(2)Who was the first president of America?
John Adams
George Washington
Thomas Jefferson
(3)Where is the Taj Mahal located?
Agra in India
Mumbai in India
Lucknow in India
(4)Where is the White house located?
New York in USA
Seattle in USA
Washington in USA
(5)What is the file extension in a file name in Excel 2007?
name.xlsx
name.xlsm
(6)Name the first three prime numbers?
2,3,4
2,3,5
2,3,6
(7)Is the density of ice less than water?
Yes
No

(8)What does the Newton’s third law of motion state?
Force=mass * acceleration
Action and reaction are both equal and opposite
Moving things keep moving. Things at rest stay at rest

(9)Does God exist?
Yes
No
I don’t know

Note: Any answer for this question is given ‘1’ point.

(10)Any form of energy can be transformed into another form, but the total energy always remains the same.
True
False

Further reading:
A NEW TOOL FOR CREATING MULTIPLE CHOICE TESTS AND REVIEWS IN MICROSOFT® POWERPOINT

Leave a Reply

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