Question: I need help figuring out the formulas for each column in excel D4 begin{tabular}{|l|l|l|l|l|l|l|l|} hline A & B & C & D & E &
D4 \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline A & B & C & D & E & F & G & H \\ \hline \end{tabular} 1 O'Rourke Enterprises 2 Maintenance Department - Weekly Payroll \begin{tabular}{|l|l|r|c|c|c|c|c|} \hline 3 & Employee & Hrly. Rate & Hours & Gross & W/H Tax & SS Tax & Net \\ \hline 4 & Williams, Pamela & $43.00 & 40 & & & & \\ \hline 5 & Ternes, Reynaldo & 41.50 & 40 & & & & \\ \hline 6 & Sinclair, Jason & 38.00 & 30 & & & & \\ \hline 7 & Pierson, Rhea & 38.00 & 40 & & & \\ \hline 8 & Nyegaard, James & 25.00 & 25 & & & \\ \hline 9 & Lunde, Beverly & 21.00 & 40 & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Withholding rate & 28% \\ \hline Social Security rate & 7.65% \\ \hline \end{tabular} D4 \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline A & B & C & D & E & F & G & H \\ \hline \end{tabular} 1 O'Rourke Enterprises 2 Maintenance Department - Weekly Payroll \begin{tabular}{|l|l|r|c|c|c|c|c|} \hline 3 & Employee & Hrly. Rate & Hours & Gross & W/H Tax & SS Tax & Net \\ \hline 4 & Williams, Pamela & $43.00 & 40 & & & & \\ \hline 5 & Ternes, Reynaldo & 41.50 & 40 & & & & \\ \hline 6 & Sinclair, Jason & 38.00 & 30 & & & & \\ \hline 7 & Pierson, Rhea & 38.00 & 40 & & & \\ \hline 8 & Nyegaard, James & 25.00 & 25 & & & \\ \hline 9 & Lunde, Beverly & 21.00 & 40 & & & \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline Withholding rate & 28% \\ \hline Social Security rate & 7.65% \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
