Complete problem $13\mathrm{.}2$ on page $413.$

You do NOT need to complete this problem in Excel

For part a you do NOT need to calculate totals, just identify which fields you could use to calculate each type of batch total

$\backslash$table$[[\backslash$table$[[$Employee$],[$Number$]],$Pay Rate,$\backslash$table$[[$Hours$],[$Worked$]],$Gross Pay,Deductions,Net Pay$],[468921,15\mathrm{.}00,7128,420\mathrm{.}00,325\mathrm{.}00,95\mathrm{.}00],[357942,16\mathrm{.}50,50,825\mathrm{.}00,205\mathrm{.}00,620\mathrm{.}00],[816543,5\mathrm{.}00,40,200\mathrm{.}00,45\mathrm{.}00,245\mathrm{.}00],[963248,{57\mathrm{.}60}_{?},{40}_{?},{2304\mathrm{.}00}_{?},10\mathrm{.}00,{2294\mathrm{.}00}_{?}$