EYM Group interview question

How to calculate weighted average (Excel)