Boards
excel question
I KNow! exciting friday afternoon here
anyway, teacher has got a google form with various multiple choice questions - with sentence type answers, is there a way the responses sheet can produce a if the answer is suchandsuch then make cell 1, or 0 so if essentially can then self mark?
I am v bad at excel but feel it should be possible...all I have managed is to turn the correct answers green :)