Step 4 . Go to Sheet 2 and Rename the tab, Employees b. In Column D, create a column titled "Annual Salary". Wrap the text on the title. Using a formula, based off of the national standard for full-time workers per year, according to the U.S. Office of Personnel Management, c. in Column E, create a column titled "Annual Health Ins Cost". Wrap the text on the title. Using a formula, compute the annual cost of Health Insurance for each employee I d. in Column F, create a column titled "Annual Workers Comp Cost". Wrap the text on the title. Using a formula, compute the annual cost of Worker's Comp Insurance for each employee e In Column G, create a column titled "Annual Unemp. Ins. Cost". Wrap the text on the title. Using a formula, compute the annual cost of Unemployment Insurance for each employee. f. In Column HI, create a column titled "Total Emp. Cost". Using a formula, compute the annual costs for each employee. (Salary and all Insurance) 8. Using a Formula, compute all Total Columns. Merge and Center Acme Industries and Admin Employees across the data. h. Sort the data based upon Employee Name, Ascending. Make sure the data stays aligned correctly to the employee Create a 3D Pie Chart that shows the Total Employee Cost by %. Name the chart, "Your Initials Employee cost." (Use your own initials) Move the Legend to the right of the chart C19 fr B C D E F G H 1 K 27.5 35 32 20 20 18 5 5 A 4 Antsy Cub 5 Wile E. Coyote 6 Road Runner 7 Bugs Bunny 8 Daffy Duck 9 Foghorn Leghorn 10 Yakko 11 Wakko 12 Dot 13 Pinky 14 Brain 15 Slappy Squirrel 16 17 Totals 18 19 Insurance Rates 20 Health 21 Workers Comp 22 Unemployment 23 24 42 35 7.5 23 20 18 10 10 12 25 20 25 8 30 10 25 % 0.29 0.09 0.16 3 Products Employees Sheet3 Sheet Ready Step 4 . Go to Sheet 2 and Rename the tab, Employees b. In Column D, create a column titled "Annual Salary". Wrap the text on the title. Using a formula, based off of the national standard for full-time workers per year, according to the U.S. Office of Personnel Management, c. in Column E, create a column titled "Annual Health Ins Cost". Wrap the text on the title. Using a formula, compute the annual cost of Health Insurance for each employee I d. in Column F, create a column titled "Annual Workers Comp Cost". Wrap the text on the title. Using a formula, compute the annual cost of Worker's Comp Insurance for each employee e In Column G, create a column titled "Annual Unemp. Ins. Cost". Wrap the text on the title. Using a formula, compute the annual cost of Unemployment Insurance for each employee. f. In Column HI, create a column titled "Total Emp. Cost". Using a formula, compute the annual costs for each employee. (Salary and all Insurance) 8. Using a Formula, compute all Total Columns. Merge and Center Acme Industries and Admin Employees across the data. h. Sort the data based upon Employee Name, Ascending. Make sure the data stays aligned correctly to the employee Create a 3D Pie Chart that shows the Total Employee Cost by %. Name the chart, "Your Initials Employee cost." (Use your own initials) Move the Legend to the right of the chart C19 fr B C D E F G H 1 K 27.5 35 32 20 20 18 5 5 A 4 Antsy Cub 5 Wile E. Coyote 6 Road Runner 7 Bugs Bunny 8 Daffy Duck 9 Foghorn Leghorn 10 Yakko 11 Wakko 12 Dot 13 Pinky 14 Brain 15 Slappy Squirrel 16 17 Totals 18 19 Insurance Rates 20 Health 21 Workers Comp 22 Unemployment 23 24 42 35 7.5 23 20 18 10 10 12 25 20 25 8 30 10 25 % 0.29 0.09 0.16 3 Products Employees Sheet3 Sheet Ready
