Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000...

  

Transcribed Image Text:

Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000 Bonus above/below 5000 Cost of Total Jyr. Financial Annual Ling Salary Multiplier Payment Salary $84 250 Monthly Car Adjusted Location New York Washington DC $68 000 Houston Patsburgh $200 SO $389 $375 $275 2.10 1.40 $52,100 $48 750 $85.000 0.94 0 92 1.2 LA Average Adusted Salary Lowest Adjusted Salary Highest Adusted Salary 2nd lawest Adjusted Salary 2rd largest Adjusted Salary positions wbonus exceed 5000 1- In the range of cells F2:F6 calculate the adiusted salary: the annual salacy divided by the cost of living multiglier minus the expected annual.car payment 2- In the range of cells H2:H6 calculate the Total 2r. 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: Adiusted Salany Bonus, Total Zyr. Financial Package & Total Byr. Financial Package. S- Write a formula to determine the value of the lowest adiusted salary. 6- Write a formula to determine the value of the highest adiusted salary. 7- Write a formula to determine the value of the Z lowest adjusted salany 8- Write a formula to determine the value of the 2 largest adiusted salany 9- Write a formula to determine the # positions w/bonus that exceeds a 5c00 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 12:1S 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, Adusted Salany Istal Rer. Einancial Package. Total 3yr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adiusted salary in red. Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000 Bonus above/below 5000 Cost of Total Jyr. Financial Annual Ling Salary Multiplier Payment Salary $84 250 Monthly Car Adjusted Location New York Washington DC $68 000 Houston Patsburgh $200 SO $389 $375 $275 2.10 1.40 $52,100 $48 750 $85.000 0.94 0 92 1.2 LA Average Adusted Salary Lowest Adjusted Salary Highest Adusted Salary 2nd lawest Adjusted Salary 2rd largest Adjusted Salary positions wbonus exceed 5000 1- In the range of cells F2:F6 calculate the adiusted salary: the annual salacy divided by the cost of living multiglier minus the expected annual.car payment 2- In the range of cells H2:H6 calculate the Total 2r. 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: Adiusted Salany Bonus, Total Zyr. Financial Package & Total Byr. Financial Package. S- Write a formula to determine the value of the lowest adiusted salary. 6- Write a formula to determine the value of the highest adiusted salary. 7- Write a formula to determine the value of the Z lowest adjusted salany 8- Write a formula to determine the value of the 2 largest adiusted salany 9- Write a formula to determine the # positions w/bonus that exceeds a 5c00 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 12:1S 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, Adusted Salany Istal Rer. Einancial Package. Total 3yr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adiusted salary in red.

Answer rating: 100% (QA)

A B D E G H K 2 yr fin pack F2G2F21025G2 H2G2103F2 FG250005000 morebelow 5000 F3G3F31025G3 H3... View the full answer