Really not good with doing this stuff with cell refs if i could get help with this that would be great

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). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: Name Hours Worked Straight Time Rate $15.00 $17.00 $22.00 Beginning Cumulative Earnings $420.00 $540.00 $480.00 Jimmy Chew Manny Blanik Alexa King 50 38 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 positive values. Do not use a minus sign or parentheses for any values. Possible Points 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. 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places. 4 Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. a. Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. Excel Skills: 1 Use cell references, both absolute and relative. 2 Indent the credits in the journal entries using the Increase indent button in the Paragraph Group on the Home Tab. Name Payroll Data Straight Time Rate $15.00 $17.00 $22.00 Beginning Hours Cumulative Worked Earnings 461 $420,00 50 $540.00 38 $480.00 l Jimmy Chew Manny Blanik Alexa King L 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. Requirement 1 "'For columns C-E reference cells in Payroll Data table; in all erence 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Payroll Register Earnings Employee Name Regular OASDI Net Pay Beginning Cumulative Earnings Wages Expens Pay Rate Hours Worked Overtime Pay Current Period Earnings Withholdings Medicar Income Total e Tax Other Withholdin 1.457 +++++ gs Ending Cumulati ve Earnings Check No 6.22 Jimmy Chew Manny Blanik Alexa King Total 1104 1105 1106 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Employee Name Payroll Tax Register Earnings Employer Payroll Taxes Beginning Current Ending OASDI Medicare FUTA | SUTA Cumulative Period Cumulati Earnings Earning ve 6.27 1.45% 0.602 5.407 Total Taxes Jimmy Chew Manny Blanik Alexa King Total Requirement 3 Compute the total payroll expense for the week ended March 31. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Amount Description L Total Gross Pay Payroll Tax Expense Total G H Requirement Record the payroll entry Ankelmakes for wages expense related to the three employees on Saturday, March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 con eyes yen anu pandudinys: Record the payroll entry Ankelmakes for employer payroll taxes related to the three employees on Saturday, March 31, Requirement 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 Modemovers powity Sypen. Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, Requirement April 3, 2018 (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70cnozunen. Wtay kawieres Requirement Record the payroll entry Ankelmakes for payment of wages on Tuesday, April 3, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 100 paunen' nayes: HINTS 1. For all dates, enter the date in mm/dd/yyyy format. cell Hint: C5:09 In appropriate cells, use cell references to Payroll Register table in ENTERANSWERS1 worksheet. C16:D20 In appropriate cells, use cell references to Payroll Tax Register table in ENTERANSWERS1 worksheet. C28:032 In apprbpriate cells, use cell references to the values in ENTERANSWERS2 worksheet. C33:033 | In appropriate cell, use the function=SUM ) to calculate the amount of the transaction C40:041 In appropriate cells, use cell references to Payroll Register table in ENTERANSWERS1 worksheet. 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). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA-OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 follows: Name Hours Worked Straight Time Rate $15.00 $17.00 $22.00 Beginning Cumulative Earnings $420.00 $540.00 $480.00 Jimmy Chew Manny Blanik Alexa King 50 38 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 positive values. Do not use a minus sign or parentheses for any values. Possible Points 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. 3 Compute the total payroll expense for the week ended March 31. Format to two decimal places. 4 Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. a. Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. Excel Skills: 1 Use cell references, both absolute and relative. 2 Indent the credits in the journal entries using the Increase indent button in the Paragraph Group on the Home Tab. Name Payroll Data Straight Time Rate $15.00 $17.00 $22.00 Beginning Hours Cumulative Worked Earnings 461 $420,00 50 $540.00 38 $480.00 l Jimmy Chew Manny Blanik Alexa King L 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. Requirement 1 "'For columns C-E reference cells in Payroll Data table; in all erence 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Payroll Register Earnings Employee Name Regular OASDI Net Pay Beginning Cumulative Earnings Wages Expens Pay Rate Hours Worked Overtime Pay Current Period Earnings Withholdings Medicar Income Total e Tax Other Withholdin 1.457 +++++ gs Ending Cumulati ve Earnings Check No 6.22 Jimmy Chew Manny Blanik Alexa King Total 1104 1105 1106 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. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Employee Name Payroll Tax Register Earnings Employer Payroll Taxes Beginning Current Ending OASDI Medicare FUTA | SUTA Cumulative Period Cumulati Earnings Earning ve 6.27 1.45% 0.602 5.407 Total Taxes Jimmy Chew Manny Blanik Alexa King Total Requirement 3 Compute the total payroll expense for the week ended March 31. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Amount Description L Total Gross Pay Payroll Tax Expense Total G H Requirement Record the payroll entry Ankelmakes for wages expense related to the three employees on Saturday, March 31, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 con eyes yen anu pandudinys: Record the payroll entry Ankelmakes for employer payroll taxes related to the three employees on Saturday, March 31, Requirement 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 Modemovers powity Sypen. Record the payroll entry Ankel makes for payment of all payroll taxes (employee and employer related) on Tuesday, Requirement April 3, 2018 (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70cnozunen. Wtay kawieres Requirement Record the payroll entry Ankelmakes for payment of wages on Tuesday, April 3, 2018. (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Date Account/Explanation DR 70 100 paunen' nayes: HINTS 1. For all dates, enter the date in mm/dd/yyyy format. cell Hint: C5:09 In appropriate cells, use cell references to Payroll Register table in ENTERANSWERS1 worksheet. C16:D20 In appropriate cells, use cell references to Payroll Tax Register table in ENTERANSWERS1 worksheet. C28:032 In apprbpriate cells, use cell references to the values in ENTERANSWERS2 worksheet. C33:033 | In appropriate cell, use the function=SUM ) to calculate the amount of the transaction C40:041 In appropriate cells, use cell references to Payroll Register table in ENTERANSWERS1 worksheet