quiz set up

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Hi Gary,

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

André




Dave Peterson said:
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.
Click to expand...
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
 
Back
Top