boza is offlineAdd to boza's Reputation
boza's Avatar
boza
Flame Thrower
Join Date: Jan 2008
Posts: 762

EXCEL help.. with formula's

POSTED BY: boza 2 weeks, 2 days 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

Tags: (Add a tag)


Reply    
Thread Tools   

 

#2

07-11-2009, 19:05
ChrisUK is offline  
ChrisUK's Avatar
ChrisUK
Solar Flare
ChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating upChrisUK is heating up
 
Join Date: Mar 2005
Location: Liverpool
Posts: 5,865
View FS/FT Feedback
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 ?
Reply With Quote

#3

07-11-2009, 19:09
pghstochaj is offline  
pghstochaj
Solar Flare
pghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating uppghstochaj is heating up
 
Join Date: Jan 2008
Posts: 2,749
View FS/FT Feedback
Use VBA instead of pure Excel functions.
Reply With Quote

#4

07-11-2009, 19:21
boza is offline  
boza's Avatar
boza
Flame Thrower
boza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of light
 
Join Date: Jan 2008
Posts: 762
View FS/FT Feedback
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.
Reply With Quote

#5

07-11-2009, 19:22
boza is offline  
boza's Avatar
boza
Flame Thrower
boza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of lightboza is a glorious beacon of light
 
Join Date: Jan 2008
Posts: 762
View FS/FT Feedback
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
Last edited by boza : 07-11-2009 at 19:48.
Reply With Quote