( ​Passing​) to reference the cell containing 70. Copy the function to the range Y4: Y21.
11 In cell B24, enter a function to calculate the average
6.000 score for the Assignment 1 values stored in the range B3: B21. Copy the function to the range C24: W24.
12 In cell B25, enter a function to calculate the median
6.000 score for the Assignment 1 values stored in the range B3: B21. Copy the function to the range C25: W25.
13 In cell B26, enter a function to display the low score for
6.000 the Assignment 1 values stored in the range B3: B21. Copy the function to the range C26: W26.
14 In cell B27, enter a function to display the highest score
6.000 for the Assignment 1 values stored in the range B3: B21. Copy the function to the range C27: W27.