excel question 4,1

profileBayhawks22
Week4ExcelAssignment11.xlsx

Paystub-Macro Example

ID Employee Name Address Frequency Salary Tax Rate Insurance 401k
154 Paige Jones 427 John A. Creighton Boulevard Anytown, USA 12345 26 42,900.00 15% 100.00 8%
240 Elijah Ward 888 192nd Street Anytown, USA 12345 26 64,600.00 16% 200.00 7%
319 Elizabeth Marshall 530 Dodge Street Anytown, USA 12345 52 72,300.00 24% 300.00 3%
331 Cooper Smith 271 Dodge Street Anytown, USA 12345 12 99,700.00 20% 300.00 5%
428 Isabella Harris 715 136th Street Anytown, USA 12345 26 57,600.00 25% 100.00 5%
451 Kaylee Perez 772 North 30th Street Anytown, USA 12345 12 82,800.00 23% 200.00 7%
527 Kimberly Hall 652 Regency Parkway Drive Anytown, USA 12345 12 41,700.00 17% 300.00 4%
540 Jesus Clark 803 Fontenelle Boulevard Anytown, USA 12345 52 83,100.00 18% 200.00 5%
665 Kylie Woods 245 Fontenelle Boulevard Anytown, USA 12345 26 70,400.00 21% 100.00 1%
981 Jackson Stephens 827 Harrison Street Anytown, USA 12345 52 50,200.00 18% 100.00 8%
Employee ID Employee Name Check # Net Pay
1
Employee Address
Pay Deductions
Taxes
Insurance
Retirement (401 k)
Total