Quote Originally Posted by Zer0Cool View Post
however no matter what approach you take I see them all being able to be circumvented.
Quoting myself on this one, the gist hasnt changed. To clarify:

NOTHING you do in Excel will prevent someone from retaking the test if it is administered in Excel.

It may deter them, slow them down, make it impractical to take beyond the limit, etc. However anyone who really wants to circumvent any limitations you put in place can and will.

Your options are:
  • Come up with a way to verify the results (like you have)
  • Move your testing to a program made for testing