Question: 9 . In cell K 9 , create a formula using the SUM function that calculates the total of the range E 1 7 :E
In cell K create a formula using the SUM function that calculates the total of the range E:E and subtracts it from the value in cell J
In cell K create a formula using the SUM function that calculates the total of the range F:F subtracts it from the value in cell J adds the total of the range G:G and subtracts
Copy the formula in cell J to cell K
In cell J create a formula using the AVERAGE function that calculates the average of the range B:F
In cell J create a formula using the MAX function that returns the maximum value from the range B:F
In cell J create a formula using the MIN function that returns the minimum value from the range B:F
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
