Golf Score averaging

Each time we play a round of golf, we keep our last 7 rounds and average out our score.
I manually input the last score in column B.
I then manually copy and paste from C4 to H4 into D4. What this does is to move the scores over to the right and dropping the oldest score out.

Questions: 1. Can the copying & pasting happen automatically when I input a score in column B? Is there a formula that can do this?
2. In column J, can it average only the 5 scores and drop the lowest & highest score? Looking formula that removes the highest & lowest, then average the rest of the scores.
3. Also looking to add in column K, if there's a way it can rate the lowest to highest score with a 1 to 5 automatically after inputting the scores?

I wasn't sure also if I should be using a table format. The only reason I used it was to either add or omit players. Any ideas or thoughts?
I'm not even sure if I'm using the average formula correctly. Was trying to eliminate a #error or #value in a blank cell.

Thank you FlameRetired & menem. This helps.
I'm not very good at VBA but if I do use VBA I'll probably be asking for help again.