Question: what is the formula in excel for weighted average?
Answer: The SUMPRODUCT function multiplies each Test's score by its weight, and then, adds these resulting numbers. We then divide the outcome of SUMPRODUCT by the SUM of the weights. And this returns the Weighted Average of 80.