A final exam is worth more in terms of graduation score and the term weighted average becomes relevant. In such cases, SUMPRODUCT formula can help calculate the weighted totals of a data set.
Read the full article here: https://www.spreadsheetweb.com/how-to...