Excel training videos

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
(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?
(6)Name the first three prime numbers?
(7)Is the density of ice less than water?

(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?
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.

Further Reference

Quiz in Excel 2007