Question: Help please File Edit Insert Format Help x table [ [ A , B ] , [ 4 , Name ] , [ 7

Help please
File Edit Insert Format Help
x
\table[[A,B],[4,Name],[7,Jimmy Chew],[8,Manny Blanik],[1,Alexa King],[1,Requirement 1],[2,]]
Complete the Payroll Register for the three employees for the week ended March 31,2018. Note that Ankel pays time-and-a-half for overtime. **For columns C - E, reference cells in Payroll Data table; in all other columns, reference cells within Payroll Register table.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or the Payroll Data table or if you type the numbers in, you will be marked wrong.)
\table[[Payroll Register],[Employee Name,Earnings,Withholdings,Net Pay,\table[[Check],[No]],\table[[Wages],[Expense]]],[\table[[Beginning],[Cumulative],[Earnings]],Pay Rate,\table[[Hours],[Worked]],Regular Pay,\table[[Overtime],[Pay]],\table[[Current],[Period],[Earnings]],\table[[Ending],[Cumulative],[Earnings]],OASDI,Medicare,\table[[Income],[Tax]],Other,\table[[Total]]],[6.2%,1.45%,20.00%,,],[Jimmy Chew,,,,,,,,,,,,,,1104,],[Manny Blanik,,,,,,,,,,,,,,1105,],[Alexa King,,,,,,,a,,,,,,,1106,],[Total,,,,,,,,,,,E,,,,]]
Requirement 2 Complete the Payroll Tax Register for the week ended March 31,2018.
**For columns C & D, reference cells in Payroll Register table; in all other columns, reference cells within Payroll Tax Register table.
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or the Payroll Data table or if you type the numbers in, you will be marked wrong.)
\table[[Payroll Tax Register],[Employee Name,Earnings,Employer Payroll Taxes],[\table[[Beginning],[Cumulative],[Earnings]],\table[[Current],[Period],[Earnings]],\table[[Ending],[Cumulative],[Earnings]],OASDI,Medicare,FUTA,SUTA,Total Taxes],[6.2%,1.45%,0.60%,5.40%
 Help please File Edit Insert Format Help x \table[[A,B],[4,Name],[7,Jimmy Chew],[8,Manny Blanik],[1,Alexa

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!