Task
Create a spreadsheet "Pop Quiz".
Instructions
(a) Choose a topic. You can pick a movie, a book, a musical artist or group, a field of science, or anything else.
(b) Write down ten questions (with their answers) about that topic.
(c) Create a new spreadsheet, and save it as "Quiz.xlsx".
(d) Type the questions in separate cells, running down the sheet.
(e) Next to each question, highlight a cell to be the answer cell.
(f) Next to the answer cells, make a cell that checks whether the answer is right or wrong.
(g) At the bottom, make a cell that adds up all the correct answers, and gives a score out of 10.
Hints
This works best if the answers are short (a number or a single word). If the answer is long, there is a chance of writing the answer in more than one way, so a player will be "wrong" even if they are right.






