Complete the following: 1. Open the workbook named Jobs-1.xlsx attached with the data of the assignment, and then save the file as 1-1-Job-Analysis1-Your-Name.xlsx. 2. In cells F2:F4, calculate the associated annual adjusted salary.This adjusted salary is the annual salary divided by the cost of living multiplier minus the expected annual car payments. (Note that car payments are given in dollars per month ($/month). 3. In cell F6, write a formula to calculate the average adjusted salary of the three positions. 4. In cell F7, write a formula to determine the value of the lowest adjusted salary. This formula should automatically update if any of the data inputs are later changed. 5. In cell F8, write a formula to determine the value of the highest adjusted salary. This formula should automatically update if any of the data inputs are later changed.

6. In cell G9, write a formula to determine the number of positions that include a bonus.

7. In cells H2:H4, calculate the value of the adjusted salary package for each position over a two-year period, including bonuses. The bonus does not need to be adjusted for location (multiplied by location factor) because the employee plans to use the bonus toward a vacation. Assume that the employee will receive a 5.5% raise after the first year of employment in the new position. Adjusted Salary + (Adjusted Salary*5.5%) + Bonus

8. Display dollar values in columns E to H without cents, and include a dollar sign only in the first row of columns with dollars. Format the cost of living multipliers with two decimal places displayed, and align these values on the decimal point.

9. Another position for which the employee is qualified has just become available. This position, a senior consultant position, is located in Washington D.C., has an annual salary of $58,000, plus a $1,500 hiring bonus. Because the position is located in downtown Washington, assume that the employee will not be purchasing a car and that the cost of living multiplier is 2.4. Insert the data for this new position just below the New York position. Complete the calculations for the adjusted salary and the total two- year financial package.

2

WEEK # 2 - EXERCISES CHAPTER # 1

Verify that all of the other values you've calculated update correctly. Adjust the formatting of the new data, as needed, to match the formatting of the existing data. 10. Highlight in yellow the row of the position with the highest two-year financial package, and bold the text in this row. 11. Add your name at the end of the exercise and date in the cell A50. 12. Save and close the 1-1-Job-Analysis1-Your-Name.xlsx workbook.