Checkboxes: Place Identical Check Boxes in Entire Column?

Hello, everyone. I am using Excel 2010 on Windows 10. I rarely use Excel, so please consider me a novice.

I'm designing a spreadsheet for my movie collection. The purpose of it is to keep track of where my movies are in my home. It's nothing fancy, but I do want to include a few odds and ends. (I've designed a database that has more detailed information. This spreadsheet is a stripped-down version of the database.)

I want to include a column for Foreign movies. This column should have a checkbox in each cell. I want the default setting to be unchecked. If I check the box, it means the corresponding film is foreign. So, I want the value to be yes/no. I do not want or need the actual value to be displayed in the spreadsheet.

As of right now, I know how to put one checkbox in a cell. But I do not know how to put a check box in every cell in the column (excluding the header row, which says "Foreign").
So, a couple of simple questions, please.

1) Is it possible to put checkboxes in an entire column, excluding the header row, and have the checkboxes refer to the same information? By "the same information," I mean each checkbox should be yes/no. Yes, if checked.
2) I will eventually want to tally up all of the checked boxes. My goal is to tally up all of the rows with information in them (in other words, a total count of movies), tally up all of the checked boxes in the Foreign column, and have a cell that displays what percentage of total movies are foreign. For example, if I have a total of 100 movies, and 18 of them are checked in the Foreign column, then 18% of my total movies are foreign. I'm sure this is possible, but what I have not yet figured out is how to create a formula that counts all of the rows EXCEPT empty ones. Is that possible to do?

That's what I need to start off with. I'm attaching a copy of my spreadsheet so you can see what I'm doing. Thank you so much! Jd

Instead of checkboxes, use the worksheet doubleclick event to write/clear "Yes" in column E:

I was able to view your modified spreadsheet. Thank you.

I was thinking about something...
Would it be easier to just type an X or an F (for Foreign) in the column?

Or would that make doing formulas more difficult?

It would make no difference to the formula whether (or what) you type directly in the cell or doubleclick it.