Question: 9 . In cell K 9 , create a formula using the SUM function that calculates the total of the range E 1 7 :E

9. In cell K9, create a formula using the SUM function that calculates the total of the range E17:E20 and subtracts it from the value in cell J9.
10. In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cell J10, adds the total of the range G17:G20, and subtracts 160.
11. Copy the formula in cell J11 to cell K11.
12. In cell J16, create a formula using the AVERAGE function that calculates the average of the range B9:F12.
13. In cell J17, create a formula using the MAX function that returns the maximum value from the range B9:F12.
14. In cell J18, create a formula using the MIN function that returns the minimum value from the range B9:F12.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!