I need to solve these with Excel. I did a. Could you explain me b and c in detail please?

I need to solve these with Excel. I did a. Could you explain me b and c in detail please?

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
Order Now