Hello new to the form.

I have an Excel sheet with column where I keep track if I received a document. So the answers can either be Yes or No. Is there a way to have y/Y answers autofill/autocorrect to Yes? Where simply typing y or Y will automatically change to Yes?

Then have another cell, where I automatically populate the total number of Yes answers so I can keep a running total at the top of the sheet. I tried googling it and non of the answers seemed to work. Thank you in advance!

This is Excel 2010 for a PC.