J H G TI E B A D 1 2 Salary 4 Old New Annual Length of Amount of Annual Employee Salary Service Raise Carbone 43,000 Jacobs 48,000 5 5 Pena 54,000 7 6 AIR 62,000 11 7 Reilly 39,000 1 8 Chung 56,000 3 9 10 11 12 1. Create the spreadsheet shown above. Save it as YOURLASTNAME Salary Raise 13 2. Format the dollar amounts as currency with no decimals. 14 3. Calculate the Amount of Raise: if the length of Service is 6 years or more, the raise is 8% (multiply by .08) 15 If the Length of service is under 6 years, the raise is 5% (multiply by .05). 16 S. Calculate the New Annual Salary by adding the Old Annual Salary plus the Amount of Raise 17 S. Format the spreadsheet attractively. 186. Add your name to a custom header. 197. Follow your teacher's instructions for printing or dropping off