SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 338 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 16 Dec 2017 My Price 10.00

Calculate the full years worked in Column D

 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

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 16 Dec 2017 02:12 PM My Price 10.00

-----------  ----------- 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

Not Rated(0)