Movie Quiz in Excel

[Guest]

Hiya!
I'm compiling a movie quiz where people have to identify a film and type it in. They get awarded one point for each correct answer. At the moment I'm using the IF function to award the point (e.g. =IF(A1="The Terminator",1,IF(A1="Terminator 2",1,0)). Obviously I don't want people to see these formulas but when I hide the formulas and then protect the sheet they can't type in their answers. How can I get around this? All help very gratefully received!

 

[Juan Pablo González]

Before protecting the sheet, unlock the cells that they will enter the answers in (In this case, A1). Then protect the sheet. They'll be able to enter data and won't see the formulas either.

 

[Anne Troy]

To unlock the cells as Juan has said, select the cells, hit Format-Cells-Protection and uncheck the Locked checkbox.

 

[Guest]

Legend.

Thank you ever so much.

Anna.