Question $1$

Calculate 'Overall Average' using excel formula, you see result is

Medium because of below defined rating:

High $=3$

Medium $=2$

Low $=1$

you can claculate rating for $3$ rd row $(\frac{3+2+1}{3})$ which results $2$ and

we have MEDIUM$=2,$ so output in cell would be medium.

Define a formula in cell D$3$ to achieve this.