N c 0 G K M 1 Catelute Payroll Deddions and Net Pay for Employees. Use Absolute Addressing where appropriate and Use Call Addresses in formules, not numeric values 2 Employee List Payroll Deductions Federal Sor ser Employee Name Department Dependents Salary Medicare Std. Deduction for Tax Net Pay Tax Tax Federal income Tax Rate: 255 each dependenti $4.000 4 Page, La 1 554 550 Social Security Tax Rate: 6208 Up to Me Salary $118.500 5 Taylor, Hector Sales $26.95 Medicare Tax Rate: 145 Up to Max Salary $200,000 5 Dawson, loan Administration 1 $147.540 Weber, Larry ADC 2 $72310 8 Pratt, Erik . $60830 1. In A, enter the formula to calculate Federal Tax for the Pape 9 Spencer, Boyd Marketing 1 566.580 2. Copy the formule in 4 down to Ens. 10 Wien, Frank Training 1 $75.150 11 Toner, Timothy Sales 3. in 4, enter the formule to calculate Social Sec. Tax for Lisa Page 1 $30,780 12 Chane, Troy Training 4. Copy the formata in 4 down to F1s. $49,350 13 wins, les Marketing 5. In A, enter the formule to calculate Medicare Test for the Page 1 $79760 16 White, Daniel Administration 6. Copy the formula in down to G1S. 2 $274,300 7.in , enter the formula to calculate Net Pay for Lisa Page 15 Holland, Donald Training $29.070 16 TOTAL B.Copy the formule in down to HIS Fedtas Deductionary Federatius enderecedent detection Social Security Tax Deduction or Maximum Salary, then Salary Sat, otherwise s Maximum Salary S5 Tute 29 Medicare Deduction aly