Question $3)$ Write a Hookup function to return the commission rate of employees in $2014$ based on their years of experience. You need to use the commission rate Look$-$up table.

Question $4)$ the average Salary Lookup table shows the average salary of employees in the same industry based on their title in Texas, Oklahoma, and Colorado. Write a lookup function in cell G$2$ to return the average salary of employees in Oklahoma.

Question $5)$ using the return value of the nested if function in question $2,$ you're going to compare the average sales of VPs with High and Medium experience levels. If sales of VPs with a High experience level are greater than VPs with a Medium experience level, cell M$18$ should show "High" otherwise it should show "Medium".

Question $6)$ by using an advanced filter, filter the table in a way that it only shows the sedans with manual transmission and under $100,000$ miles.