Insert in the Current Values section at the top of the worksheet summary functions that use the range I9:I54. In cell I2, calculate the total of all the Current Values. In cell I3, calculate the average current value. in cell I4, calculate the lowest current value. In cell I5, calculate the highest current value

Cell I2: =SUM(I9:I54)

Cell I3: =AVERAGE(I9:I54)

Cell I4: =MIN(I9:I54)

Cell I5: =MAX(I9:I54)

Explanation:

I wasnt able to find the worksheet referenced, however it is not needed to answer correctly.

The question states there are several values in the cell range I9:I54, and we need to perform different operations:

To obtain the TOTAL calculation, we use the SUM function for all the range of values

=SUM(I9:I54)

Average is calculated with the function named the same

=AVERAGE(I9:I54)

The lowest value of all the range is found with the MIN function

=MIN(I9:I54)

The highest value of all the range is found with the MAX function

=MAX(I9:I54)

hi, you. i think this we be deleted because it's a invalid question.

(i suggest no to do this in the