pleae complete questions 9 through 12, thank you!
Total 3yr. Financial Package Bonus above/below 5000 Cost of Annual Living Monthly Car Adjusted Location Salary Multiplier Payment Salary New York 584 250 2.10 $200 Washington DC 568.000 1.40 so Houston $52,100 0.94 Pittsburgh $48,750 0.92 $375 LA $85.000 12 $275 Total 2yr. Financial Bonus Package 55.000 $1,500 $1,500 $5,500 $2,000 $389 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:16 calculate the Total 2yr. 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. 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. Total 3yr. Financial Package Bonus above/below 5000 Cost of Annual Living Monthly Car Adjusted Location Salary Multiplier Payment Salary New York 584 250 2.10 $200 Washington DC 568.000 1.40 so Houston $52,100 0.94 Pittsburgh $48,750 0.92 $375 LA $85.000 12 $275 Total 2yr. Financial Bonus Package 55.000 $1,500 $1,500 $5,500 $2,000 $389 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:16 calculate the Total 2yr. 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. 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
