Using Microsoft Excel

This program is one that ive had little to do with and i struggled more with this exercise. Whilst I knew how to enter the basic data, i was confused by the formula questions and it took me a few tries to get it to turn out properly. I had used graphs in excel before though and was happy to breeze through that question but then i got stuck on the macro advanced question which I still haven't managed to work out.