Question

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

Answer 1

Cell I2: =SUM(I9:I54)

Cell I3: =AVERAGE(I9:I54)

Cell I4: =MIN(I9:I54)

Cell I5: =MAX(I9:I54)

Step-by-step 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:

• In cell I2, calculate the total of all the Current Values

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

=SUM(I9:I54)

• In cell I3, calculate the average current value

Average is calculated with the function named the same

=AVERAGE(I9:I54)

• In cell I4, calculate the lowest current value

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

=MIN(I9:I54)

• In cell I5, calculate the highest current value

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

=MAX(I9:I54)