Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

G Payroll Net Pay 1 2 Date: 1/1/2011 EMPL EMPL Name 3 Number 4 E00001 Ford 5 E00002 Mino 6? Bell 7 ? Davis 8?

image text in transcribed
G Payroll Net Pay 1 2 Date: 1/1/2011 EMPL EMPL Name 3 Number 4 E00001 Ford 5 E00002 Mino 6? Bell 7 ? Davis 8? Turro Hourly Rate 7.5 8 6.5 9 10 Hours Gross Payl S.S Tax Worked 35 ? ? 30 ? ? 25/? ? 40/? ? 39/? ? ? ? 12 ? ? 1. Open a new workbook and save the file with the name "Exercicel". 2. Enter the labels and values in the exact cells locations as desired. 3. Use AutoFill to put the Employee Numbers into cells A6:A8. 4. Set the columns width and rows height appropriately. 5. Set labels alignment appropriately. 6. Use warp text and merge cells as desired. 7. Apply borders, gridlines and shading to the table as desired. 8. Format cell B2 to Short Date format. 9. Format cells E4:G8 to include dollar sign with two decimal places. 10. Calculate the Gross Pay for employee; enter a formula in cell E4 to multiply Hourly Rate by Hours Worked. 11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pay; enter a formula in cell F4 to multiply Gross Pay by 6%. 12. Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from Gross Pay. 13. Save your work

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

EX 11.1 Create a UML class diagram for the ProductCodes program.

Answered: 1 week ago

Question

=+3. How will you measure action objective?

Answered: 1 week ago

Question

=+2. What research methodologies would be most effective?

Answered: 1 week ago

Question

=+ Focus groups with representative publics. Which publics?

Answered: 1 week ago