Please help with problems 9 through 13 and show all work in excel.

ok

i need help finishing. i am stuck on questions 9 throught 13.

Cost of Annual Living Location Salary Multiplier New York 84,250 2.1 Washington 68,000 1.4 Houston 52, 100 0.94 Pittsburgh 48,750 0.92 LA 85,000 1.2 Total 2yr. Total 3 yr Bonus Monthly Car Adjusted Financial Financial above/below Payment Salary Bonus Package Package 5000 200 $ 39,919.05 5,000 $ 85,836.07 $ 127,980.61 0 $ 48,571.43 1,500 $ 99,857.14 $ 151, 136.43 389 $ 55,036.53 1,500 $ 112,948.98 $ 171,053.80 375 $ 52,614.13 5,500 $ 112,043.61 $ 167,590.98 275 $ 70,558.33 2,000 $ 144,880.63 $ 219.372.59 Average adjusted Salary Lowest Adjusted Salary Highest Adjusted Salary 2nd lowest Adjusted Salary 2nd largest Adjusted Salary #positions w/bonus exceed 5000 $ 53,339.89 $ 3,100.00 $ 111,113.29 $ 167.426.88 $ 39,919.05 $ 70,558.33 $ 48,571.43 $ 55,036.53 Total 3yr. Financial Package Bonus above/below 15000 Cost of Annual Living Monthly Car Adjusted Location Salary Multiplier Payment Salary I New York $84.250 2.10 $200 Washington DC 568.000 1.40 SO Houston 552,100 0.94 $389 Pittsburgh $48.750 0.92 $375 LA $85.000 1.21 $275 Total 2yr. Financial Bonus Package 55.000 $1.500 $1.500 $5,500 $2.000 Average Adjusted Salary Lowest Adjusted Salary Highest Adjusted Salary 2nd lowest Adjusted Salary 2rd largest Adjusted Salary #positions w/bonus exceed 5000 1- In the range of cells F2:F6 calculate the adjusted salary: the annual salary divided by the cost of living multiplier minus the expected annual car payment 2- In the range of cells H2:46 calculate the Total Zyr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a two-year period, including Bonuses. Assume that the employee will receive a 2.5% after the first year of employment. 3-In the range of cells 12:16 Calculate the Total 3yr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a three-year period, including Bonuses Assume that the employee will receive bonus in the second year and third year and the employee will receive a 2.5% after the first year and 3% after the second year of employment in the new position. 4- Calculate the Averages for columns: Adjusted Salary. Bonus, Total Zyr. Financial Package & Total 3yr. Financial Package. 5- Write a formula to determine the value of the lowest adjusted salary. 6- Write a formula to determine the value of the highest adjusted salary, 7- Write a formula to determine the value of the 2nd lowest adjusted salary, 8- Write a formula to determine the value of the 2nd largest adjusted salary, Mlikala K. 1, 9. Write a formula to determine the #positions w/bonus that exceeds 4000. 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 22:15 for bonus to display "5000 & more" if bonus greater than or equal 5000 else display "below 5000" 12- create a clustered column chart to display Location Adjusted Salary, Total 2yr. Financial Package Total Byr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adjusted salary in red. Cost of Annual Living Location Salary Multiplier New York 84,250 2.1 Washington 68,000 1.4 Houston 52, 100 0.94 Pittsburgh 48,750 0.92 LA 85,000 1.2 Total 2yr. Total 3 yr Bonus Monthly Car Adjusted Financial Financial above/below Payment Salary Bonus Package Package 5000 200 $ 39,919.05 5,000 $ 85,836.07 $ 127,980.61 0 $ 48,571.43 1,500 $ 99,857.14 $ 151, 136.43 389 $ 55,036.53 1,500 $ 112,948.98 $ 171,053.80 375 $ 52,614.13 5,500 $ 112,043.61 $ 167,590.98 275 $ 70,558.33 2,000 $ 144,880.63 $ 219.372.59 Average adjusted Salary Lowest Adjusted Salary Highest Adjusted Salary 2nd lowest Adjusted Salary 2nd largest Adjusted Salary #positions w/bonus exceed 5000 $ 53,339.89 $ 3,100.00 $ 111,113.29 $ 167.426.88 $ 39,919.05 $ 70,558.33 $ 48,571.43 $ 55,036.53 Total 3yr. Financial Package Bonus above/below 15000 Cost of Annual Living Monthly Car Adjusted Location Salary Multiplier Payment Salary I New York $84.250 2.10 $200 Washington DC 568.000 1.40 SO Houston 552,100 0.94 $389 Pittsburgh $48.750 0.92 $375 LA $85.000 1.21 $275 Total 2yr. Financial Bonus Package 55.000 $1.500 $1.500 $5,500 $2.000 Average Adjusted Salary Lowest Adjusted Salary Highest Adjusted Salary 2nd lowest Adjusted Salary 2rd largest Adjusted Salary #positions w/bonus exceed 5000 1- In the range of cells F2:F6 calculate the adjusted salary: the annual salary divided by the cost of living multiplier minus the expected annual car payment 2- In the range of cells H2:46 calculate the Total Zyr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a two-year period, including Bonuses. Assume that the employee will receive a 2.5% after the first year of employment. 3-In the range of cells 12:16 Calculate the Total 3yr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a three-year period, including Bonuses Assume that the employee will receive bonus in the second year and third year and the employee will receive a 2.5% after the first year and 3% after the second year of employment in the new position. 4- Calculate the Averages for columns: Adjusted Salary. Bonus, Total Zyr. Financial Package & Total 3yr. Financial Package. 5- Write a formula to determine the value of the lowest adjusted salary. 6- Write a formula to determine the value of the highest adjusted salary, 7- Write a formula to determine the value of the 2nd lowest adjusted salary, 8- Write a formula to determine the value of the 2nd largest adjusted salary, Mlikala K. 1, 9. Write a formula to determine the #positions w/bonus that exceeds 4000. 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 22:15 for bonus to display "5000 & more" if bonus greater than or equal 5000 else display "below 5000" 12- create a clustered column chart to display Location Adjusted Salary, Total 2yr. Financial Package Total Byr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adjusted salary in red