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 &

I need help figuring out the formulas for each column in excel
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 & 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!