Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?
A. =SUMPRODUCT(C2:C5,B2:B5)B. =SUMPRODUCT(C2:C4,B2:B4)C. =AVERAGE(B2:34)D. =AVERAGE(C2:C4)
The Correct Option is B. =SUMPRODUCT(C2:C4,B2:B4)
Explanation:
This question is asking which formula, among a list of options, correctly calculates the weighted average
View or Download Samples