I am currently working on setting up a survey. I have linked the checkbox to a cell "B9" but want to be able to center it in the cell. How do you do this?

Also, I want to mine the data. Therefore, if the checkbox is checked, I want it to display a "1" on another sheet. How do I do that?

Thanks!