Checkbox Answer to Show As it Looks in the Form.
Is it possible to answer a yes or no checkbox question in google form and have it appear in the auto-generated excel sheet as a filled/shaded box with the exact same question and options even when not chosen?
So the answer checked off is filled in the sheet and the one that wasn't filled stills shows up the same way as it does in the google form.
For example, the question on the google form...
Do you like the color purple?
[ ] No
And on the excel sheet or document, I format it differently but want the answers to look the same as the form.
Do you like the color purple? [x] Yes [ ] No