Q$1.$ At cell range I$6$:I$20,$ put formulae $($VLOOKUP$)$ to compute bonus amount based on criteria and percentage at L$6$:M$9$

For example, if an employee makes more than $$60,000,$ then bonus will be $5\%$ of the salary

Q$2.$ Enter SUMIF at I$22$ to compute the total bonus for employees whose salary are $$40,000$ and more.

Q$3.$ Draw a column chart with Lname and Salary $($including axis titles and chart title$),$ and move the chart at A$25$:H$40$

Q$4.$ Sort the database using Salary as the primary key in ascending order and Lname as the secondary key in decending order

Q$5.$ Create a pivot table to show average salary by department and gender, and put that pivot table in a New Worksheet named Pivot Table. And format numbers as currency with zero decimal place.

Q$6.$ Go to Worksheet named Database. Using Data$/$Filter$,$ select females who make more than $$50,000($use Number Filters for Salary field and do not check check boxes$)$