4. (8) In cell E4, write a formula to project what Jo Bennet's total would be in August if she incr amount by the rate in cell Ed (make sure your results will update if we later change the numb 5. (8) Copy the formula down from E4 for all the other clients, making sure that each August res automatically 8% higher than the July amount for that client. 61 (4) In cell E12, figure out the average of the August amounts 7. (8) Format the July and August numbers in Accounting Number format, but showing no decin 8 (8) In G2, use a function to show the August sales amount for whichever client's ID# gets typ 9. (4) Type 45 in G1 and make sure that G2 automatically shows Rita's August number. 10. (12) In G10, use the information in F5:G7 to figure out the monthly loan payment for the car 11 (8) In G11, calculate what you would have paid for the car over all the years of the loan 12. (8) Below the data, create a pie chart of the client names and their August dollar amounts. 13. (6) Have the names and dollar amounts show outside the pie slices. 14. (2) Remove the legend from the chart. 15 (8) Change the number in cell El to show 9.359%