Using Excel to Calculate Payroll Amounts

Student Work Area

Betsy Strundls payroll information is provided here.

Regular hourly wage rate

Hourly rate for work in axcess of $40$ hours

Hours worked during a January pay period Federal income tax withholding FICA tax rate

Bessy has no voluntary deductions.

$\backslash$table$[[,],[,16\mathrm{.}00],[,24\mathrm{.}00],[,47],[,95\mathrm{.}00],[,7\mathrm{.}65\%$