EXCEL help.. with formula's - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

EXCEL help.. with formula's

£0.00 @
Hi, i am creating a quiz in excel for children in need at work. i have seen other quiz's on the internet made in excel with pictures etc. I am looking to stop people from cheating on it, and finding m…
boza Avatar
7y, 4m agoPosted 7 years, 4 months ago
Hi, i am creating a quiz in excel for children in need at work. i have seen other quiz's on the internet made in excel with pictures etc. I am looking to stop people from cheating on it, and finding my answers(i will be locking the sheet, and cells).

once the quiz is finished i will hapilly upload it to this website for your own pleasure, but i know of a way to get everysingle answer on my spreadsheet( even though it is password protected and cells are locked) but with a quiz i downloaded off the internet the same technique does, not apply.

i know this is a little vague, but i do not want to give the tecnique out to you if i am to give it people on here at a later date.

If you are very good at excel, i will glady tell you how i managed to get the answers from one but not the other.

Help please, it is going on sale at work on tuesday and im currently stuck.


Thank you
boza Avatar
7y, 4m agoPosted 7 years, 4 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
1 Like #1
You can unlock them with a very simple free program off the net. Why not get is to look up the answer from the web so the answers are not stored locally ?
1 Like #2
Use VBA instead of pure Excel functions.
#3
ChrisUK
You can unlock them with a very simple free program off the net. Why not get is to look up the answer from the web so the answers are not stored locally ?


Because it a work quiz, and not all pc's are on the internet, but thank you for the help.
#4
pghstochaj
Use VBA instead of pure Excel functions.


ive only just cracked the formulas in excel to work, i havent got time to learn the VBA side of it too. Thanks anyway. rep

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!