Worksheet Q$4$ has information about employees $($sales people$).$ Each year the company needs

to evaluate each employee$$s performance and calculate her commission rate.

Tasks:

$$ In cell B$2$ calculate the average profit earned of all employees on the list.

$$ In column E$,$ use Vlookup function to calculate each employee$$s level based on profit

earned $($column C$)$ based on the following rules:

$$

Profit Earned Level

$$250,000$ or above $3$

$>=$$$200,000$ but $<$ $$250,0002$

$>=$$$100,000$ but $<$ $$200,0001$

Less than $$100,0000$