In cell F$4$ write an Excel formula $($use cell references whenever possible$)$ which can be copied down into cells

F$5$:F$9$ that calculates the weighted score of Mary Keck$$s test values. The weights of each test are given in row $2.$

So her final weighted score will be a sum of each score multiplied by the weight of that score as follows: