( ​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 .