Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is all the information provided AutoSave b.p.8. Final Workbook Data Group C Rev File Home Insert Draw Page Layout Formulas Data Review View Help

this is all the information provided image text in transcribed
image text in transcribed
AutoSave b.p.8. Final Workbook Data Group C Rev File Home Insert Draw Page Layout Formulas Data Review View Help OS Calibri 29 Wrap Test Currency Paste - 11 - A A A. BIU- Merge & Center $ % 9 00 Clipboard Font Alignment Number D4 E G H 3 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 B .C Years of Hourly Service Rate Annual Salary 27.5 42 35 35 32 7.5 20 23 20 20 18 18 5 10 5 10 8 12 30 25 10 20 25 25 % 0.29 0.09 0.16 Products Employees Sheet3 Sheet4 Ready Type here to search Autowe 2.08 Final Spreadsheet La Directions 2) (doc Hanyi Orsi 10 File Home Draw Design Layout References Mailings Review View Help Grammy Search Share c. Create a Line Chart with markers, showing the Unit Labor Cost. Chart Title Unit Labor Cost %, black and bold text. Make sure all data is legible. d. Re-name Sheet 1 - Products Comm Step 4 a. 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 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. i. 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 1 AutoSave b.p.8. Final Workbook Data Group C Rev File Home Insert Draw Page Layout Formulas Data Review View Help OS Calibri 29 Wrap Test Currency Paste - 11 - A A A. BIU- Merge & Center $ % 9 00 Clipboard Font Alignment Number D4 E G H 3 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 B .C Years of Hourly Service Rate Annual Salary 27.5 42 35 35 32 7.5 20 23 20 20 18 18 5 10 5 10 8 12 30 25 10 20 25 25 % 0.29 0.09 0.16 Products Employees Sheet3 Sheet4 Ready Type here to search Autowe 2.08 Final Spreadsheet La Directions 2) (doc Hanyi Orsi 10 File Home Draw Design Layout References Mailings Review View Help Grammy Search Share c. Create a Line Chart with markers, showing the Unit Labor Cost. Chart Title Unit Labor Cost %, black and bold text. Make sure all data is legible. d. Re-name Sheet 1 - Products Comm Step 4 a. 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 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. i. 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 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Bookkeeping And Financial Accounting

Authors: Emile Woolf International

1st Edition

1848437552, 978-1848437555

More Books

Students also viewed these Accounting questions