Rodriguez_Miller-Nobles 6e-12e-Using Excel Ch11 Start Read-Only - E. aline alvarenga Formulas Review View Insert Draw Page Layout Data Help O Define Narme- QUse in Formula E, Trace Precedents Vir Show Formulas ... L68 Trace Dependents A Error Checking- AutoSum Recently Financial Logical Text Date & Lookup & Math & Time Reference Trig More Name Inser Calcula Option Watch Functions Create from Selection E Remove Arrows - A Evaluate Formula Manager Window Function Used - Defined Names Formula Auditing Function Library C17 P. Payroll Data 2. Straight Time Beginning Hours Cumulative Name 4. worked Earnings Rate $420.00 $15.00 46 50 $480.00 Jimmy Chew Manny Blanik Alexa King $540.00 $17.00 $22.00 38 Complete thePayroll Register for the three employees for the veek ended March 31, 2018. Note that Ankel pays time-and-a-half for ovetime "For columns C-E, reference cells in Payroll Data table; n all other columns., teference oells vithin Payroll Register table. (Alv ays use cell references and formulas where appropriate to receive ful credr. Enter all amounts as poskive values. Do not use a minus sign or parenheses for any values.) Requirement 1 10 11 12 Payroll Register Withholdings 13 Wages Earnings Check Ending 14 Medicar Income Tax Total Expens Net Pay Current OASDI No Other Withholdin Cumulati Employee Name Regular Pay Beginning Overtime Hours Pay Period Pay ve Cumulative Worked Rate Earnings 1.45% * Earnings 6.2% 15 1104 1105 Earnings 16 Jimmy Chew Manny Blanik Alexa King 17 1106 18 19 Total 20 21 22 **For columns C& D, reference cells in Payroll Register table; in all other columns, reference cells within Payrol Tax Register table (Always use cell references and formulas where appropriate to receive full credit. Enter allamounts as positive values. Do not use a minus sian or parentheses for any values.) Complete the Payroll Tax Register for the week ended March 31, 2018. Requirement 2 23 24 25 Payroll Tax Register Employer Payroll Taxes Medicare FUTA SUTA 26 Earnings Beginning Current Ending Total OASDI 27 Employee 28 ENTERANSWERS2 ENTERANSWERS1 Instructions X Rodriguez Miller-N. Enter I Rodriguez_Miller-N. O Assessment Launc. 9 Do Homework - Go. _start - Read-Only - E.. Search File Home Insert Draw Page Layout Formulas Data Review View Help fx O Define Name B, Trace Precedents A Show Formulas -