Question: Please help with this excel project. The blue boxes in the ENTERANSWERS1 and ENTERANSWERS2 are what need filled out. Thanks in advance! File Insert Page

Please help with this excel project. The blue boxes in the "ENTERANSWERS1" and "ENTERANSWERS2" are what need filled out. Thanks in advance!  Please help with this excel project. The blue boxes in the
"ENTERANSWERS1" and "ENTERANSWERS2" are what need filled out. Thanks in advance! File
Insert Page LayoutFomulas Data Revien iew Help X Cut 2 Copy Format
PaindesIU Conditional Format as Cell insert De formating- Table Styles Current Liabilities
and Payroll Using Excel for Payroll Ankel Footwear employees three salespeople, and

File Insert Page LayoutFomulas Data Revien iew Help X Cut 2 Copy Format PaindesIU Conditional Format as Cell insert De formating- Table Styles Current Liabilities and Payroll Using Excel for Payroll Ankel Footwear employees three salespeople, and pays time-and a half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Anked withholds income tax (20%), FICA-OASD' (.2%. and FICA-Medicare (LASS). Arkel also pin payoll taes Or ICA-OASDI ( 6.2%), FICA-Medicare ( 1.45%. and state and federal unemployment for the week ended March 31 follows (SAS and as% respectively). The payroll data for the three salespeople Straight Time ours Beginning Rate WorkedCumulative Jimmy Chew Manny Blanik S0$540. 3) Use the blue shaded areas on the ENTER ANSWERS tab for inputs ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Enter all amounts as 5 positive values. Do not use a minus sign or parentheses for any values Requirements: 1 Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 2 Complete the Payroll Tax Register Instructions ENTERANSWERS ENTERANSWERS2 Search the web and Windows 40 2 4 5 6 File Insert Page LayoutFomulas Data Revien iew Help X Cut 2 Copy Format PaindesIU Conditional Format as Cell insert De formating- Table Styles Current Liabilities and Payroll Using Excel for Payroll Ankel Footwear employees three salespeople, and pays time-and a half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Anked withholds income tax (20%), FICA-OASD' (.2%. and FICA-Medicare (LASS). Arkel also pin payoll taes Or ICA-OASDI ( 6.2%), FICA-Medicare ( 1.45%. and state and federal unemployment for the week ended March 31 follows (SAS and as% respectively). The payroll data for the three salespeople Straight Time ours Beginning Rate WorkedCumulative Jimmy Chew Manny Blanik S0$540. 3) Use the blue shaded areas on the ENTER ANSWERS tab for inputs ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Enter all amounts as 5 positive values. Do not use a minus sign or parentheses for any values Requirements: 1 Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. 2 Complete the Payroll Tax Register Instructions ENTERANSWERS ENTERANSWERS2 Search the web and Windows 40 2 4 5 6

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 Accounting Questions!