Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.

This is all about how to calculate weighted average in Excel with percentages. I hope you find this helpful. Also Read: How to use MIN, Max, and AVERAGE Functions of Excel.