Build the spreadsheet above and save the file as Payroll_ YourFirstName_YourLastName.xlsx Enter all formulas first then format

(1)              Calculate the full years worked in Column D, using the date in the title.

(2)              Write formulas for E7 so it can be copied: The 401(k) contribution is currently 3% of the employee's salary for employees who have worked for the company at least one full year; otherwise the contribution is zero. Be sure to use cell B24 in your formula.

(3)              Write formula for F7 so it can be copied: An employee is eligible for a bonus if he/she worked at least 3 full years. The bonus amount is $100. Be sure to use cell B25. Copy formulas to the rest of the column.

(4)              Total the salaries, 401(k) contributions and bonuses.

(5), (6), (7), (8) Find number of employees, average, highest and lowest salaries by using appropriate functions.

*Format all currency amounts with 2 decimals.

*Insert right section footer with your name, date and file name, each on a separate line. Use font size 8. See sample at the right bottom corner of this page.

*Make sure that entire content of cells is visible and spreadsheet fits on a single page. Modify margins and/or layout if needed.

*Print the worksheet and formulas.

*Then change the Company Contribution to 401(k) to 4% and bonus to $150.00.

 *Highlight the changes using Fill Color button in the Font group on the Home tab and print the values.

*Hint: you can make 2 line headings using Alt+Enter.

 

 

Thank you

 

 

ABCDEFG1Payroll Worksheet for Audio Manufacturing As of12/30/2011Your Name HereToday's date here23456EmployeeSalaryHire DateYrs. Worked401k ContribuTonBonus7Jones$4,200.002/5/2009(1)(2)(3)8Smith$5,000.007/25/2010(1)(2)(3)9Lee$7,000.006/28/2005(1)(2)(3)10 Zapata$3,000.008/22/2011(1)(2)(3)11 Lopez$4,800.001/4/2008(1)(2)(3)12 Nguyen$3,800.0010/12/2006(1)(2)(3)13 Brown$4,500.009/5/2007(1)(2)(3)1415±otals(4)(4)(4)1617StaTsTcs18 Number of employees(5)19 Average Salary(6)20 Highest Salary(7)21 Lowest Salary(8)2223AssumpTons24 Company Contribu±on3%25 Bonus$100.0026 Build the spreadsheet above and savethe ²le as Payroll_ YourFirstName_YourLastName.xlsx Enter allformulas ²rst then format(1)Calculate thefullyears worked in Column D, using the date in the ±tle.(2)Write formulas for E7 so it can be copied:The 401(k) contribu±on is currently 3% of the employee's salary foremployees who have worked for the company at least one full year; otherwise the contribu±on is zero. Be sure to use cellB24 in your formula.(3)Write formula for F7 so it can be copied: An employee is eligible for a bonus if he/she worked at least 3 full years.The bonus amount is $100.Be sure to use cell B25. Copy formulas to the rest of the column.(4)Total the salaries, 401(k) contribu±ons and bonuses.(5), (6), (7), (8)Find number of employees, average, highest and lowest salaries by using appropriate func±ons.Format all currency amounts with 2 decimals.Insert right sec±on footer with your name, date and ²le name, each on a separate line. Use font size 8. See sample at theright bo³om corner of this page.Make sure that en±re content of cells is visible and spreadsheet ²ts on a single page.Modify margins and/or layout ifneeded.Print the worksheet and formulas.Then change the Company Contribu±on to 401(k) to 4% and bonus to $150.00.Highlight the changes using Fill Color bu³on in the Font group on the Home tab and print the values.272829303132333435363738394041424344454647484950

• 1492956620-Activities.docx

ComputerScienceExpert

(11)

Status NEW Posted 23 Apr 2017 02:04 PM My Price 9.00

-----------

Attachments

file 1492956628-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer