0100 0001 0100 3. Payroll register Open the Microsoft Excel file CH14 Payroll from the data files. All employee earnings are subject to FICA deductions totaling 7.65 percent. Complete the payroll register. Correct errors in formatting, spelling, and capitalization. Check or enter formulas to complete the register. (Learning Objective 2) CAREER DATA FILE File Home Insert Draw Page Layout Formulas Data Review View Developer Help X Calibri 11 A = y ab Wrap Text Currency AT M Paste BIU CA Insert 60 E E Merge & Center y $ %) Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number E4 ... X =C4 . B - J K L 1 2 3 Employee Name Alvarez, J. Beguletti, F. Dunn, M. Park, T. Vanouer, G. Wong, M. Employee Number 4 6892 5 4589 6 5571 7 5568 8 5987 9 5688 10 Totals DE F G Payroll Register Janiary 31, 2020 Income Regular Overtime Total Tax FICA $2,115.00 $2,115.00 $232.65 $161.80 1,287.00 125.00 0.00 0.00 2,850.00 0.00 0.00 2,050.00 0.00 0.00 1,200.00 0.00 0.00 3,250.00 0.00 0.00 State tax $63.45 0.00 0.00 Health Insurance Net Pay $123.00 $1,534.10 123.00 76.00 123.00 0.00 123.00 0.00 0.00 0.00 11 12 Income tax rate: 11% 13 FICA rate: 7.65% 14 State tax rate: 3% 15 16 17 18 19 20 21 an