Spreadsheet - Pop Quiz

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.

Page tags: activity ict spreadsheet
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License