Answer Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1404332%22%20slang%3D%22en-US%22%3EAnswer%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404332%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22excel%20colorful%22%3E%3CH1%20id%3D%22toc-hId-466494570%22%20id%3D%22toc-hId-466494632%22%20id%3D%22toc-hId-466494632%22%20id%3D%22toc-hId-466494632%22%20id%3D%22toc-hId-466494632%22%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3Etrying%20to%20make%20an%20answer%20sheet%20for%201000%20question%20study%20guide%20i%20want%20to%20be%20able%20to%20input%20answer%20in%20column%20A%20and%20if%20correct%20check%20mark%20in%20B%20if%20incorrect%20X%20in%20B%20answers%20are%20a%2Cb%2Cc%2Cd%2Ce%2Cf%3C%2FFONT%3E%3C%2FH1%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1404332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1404627%22%20slang%3D%22en-US%22%3ERe%3A%20Answer%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1404627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625539%22%20target%3D%22_blank%22%3E%40johnnyg00%3C%2FA%3E%26nbsp%3Buse%20attached%20file.%3CBR%20%2F%3EYou%20need%20to%20update%20cells%20in%20%22Yellow%22%2C%20rest%20is%20auto%20calculated%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1407220%22%20slang%3D%22en-US%22%3ERe%3A%20Answer%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1407220%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethat's%20i%20awesome%20thank%20you%20but%20how%20do%20i%20do%20it%20so%20that%20they%20don't%20see%20the%20correct%20answer%20until%20they%20input%20answer%20in%20B%20column%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1407548%22%20slang%3D%22en-US%22%3ERe%3A%20Answer%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1407548%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625539%22%20target%3D%22_blank%22%3E%40johnnyg00%3C%2FA%3E%26nbsp%3Bokay%2C%20I%20have%20moved%20correct%20answers%20to%20sheet%202.%3CBR%20%2F%3EOnce%20you%20update%20Correct%20Answers%2C%20make%20that%20sheet%20'Very%20Hidden'%20so%20that%20users%20can't%20see%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHOW%20TO%20MAKE%20SHEET%20VERY%20HIDDEN%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2017%2F12%2F20%2Fvery-hidden-sheets-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2017%2F12%2F20%2Fvery-hidden-sheets-excel%2F%3C%2FA%3E%3C%2FP%3E%3CP%3Erefer%20to%20title%20%22Make%20a%20worksheet%20very%20hidden%20by%20changing%20its%20Visible%20property%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20This%20is%20not%20my%20blog%2C%20it's%20just%20for%20reference.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

trying to make an answer sheet for 1000 question study guide i want to be able to input answer in column A and if correct check mark in B if incorrect X in B answers are a,b,c,d,e,f

3 Replies
Highlighted

@johnnyg00 use attached file.
You need to update cells in "Yellow", rest is auto calculated

Highlighted

@bhushan_z 

that's i awesome thank you but how do i do it so that they don't see the correct answer until they input answer in B column

Highlighted

@johnnyg00 okay, I have moved correct answers to sheet 2.
Once you update Correct Answers, make that sheet 'Very Hidden' so that users can't see it.

 

HOW TO MAKE SHEET VERY HIDDEN:

https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/

refer to title "Make a worksheet very hidden by changing its Visible property"

 

Note: This is not my blog, it's just for reference.