quiz set up

[Guest]

I am trying to create a fill in the blank quiz where one would type their answer into a column, if correct the answer would stay visible, if incorrect the word incorrect, or try again, or something similar would appear. Does anyone know how to create this in excel. If so please email me, (e-mail address removed) Thanks

 

[Dave Peterson]

How about this:

Use a helper column with formulas like:

=if(b9="a","You are correct, sir!","Try again")

but then you'll want to hide that formula so the user can't peek.

Select the cells that the user can change.
format|cells|protection tab
uncheck locked.

Select the cells with these formulas
format|cells|protection tab
Check locked AND hidden

Then protect the worksheet (well, when you're done with the if statements)
tools|protect|protect sheet

That said worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.

 

[Andre Croteau]

Hi Gary,

You could also lookup the possibility of using the VALIDATION feature in
that cell.

André

How about this:

Use a helper column with formulas like:

=if(b9="a","You are correct, sir!","Try again")

but then you'll want to hide that formula so the user can't peek.

Select the cells that the user can change.
format|cells|protection tab
uncheck locked.

Select the cells with these formulas
format|cells|protection tab
Check locked AND hidden

Then protect the worksheet (well, when you're done with the if statements)
tools|protect|protect sheet

That said worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.

their answer into a column, if correct the answer would stay visible, if
incorrect the word incorrect, or try again, or something similar would
appear. Does anyone know how to create this in excel. If so please email me,
(e-mail address removed) Thanks