Quiz app

Hi all,
I want to make a Christmas quiz where I ask the questions and the players choose their answers in the app and in the end see the score and the winner etc. Of course I will need a sheet with questions and a sheet with players, but how do I go from there and is this possible without a complex formula in Sheets?
Erwin

I would definitely suggest to make it public with email so you can tag each answer with an email. And of course a sheet for the answers that has a link to the question as well as the email of the person who answered the question.

You would have the multiple choice answers on the row with the question so maybe 5 columns with 4 wrong answers and 1 correct answer plus a column that would indicate which of the 5 columns has the correct answer.

3 Likes

I’ve been trying what I can, but I don’t succeed :wink:
I have the idea I would have to do extra formula’s in Google Sheets.
But maybe others no more!
No Christmas Quizz app :wink:

It would have been easy if If this AND that than … would have been possible, maybe in the future

I’m not good at English.

I wanted to hear this explanation from Mr. George.

I am making a 4-choice quiz (country name quiz) for my child’s study.
惻 Sheets of quizzes and answers.
惻 A sheet for displaying one question at a time.ļ¼ˆā€œPaging and navigation using increment actionā€ I referred to this topic.)
惻 A sheet listing country names.
惻 Choice display sheet (I don’t understand here.)

What I want to do is

  1. Display one answer and three randomly selected wrong answers.

  2. Randomly arrange the four extracted options for the four answer buttons.

I would appreciate it if you could teach me as a super beginner so that I can understand it.