3	Q3 - Using Data Set B, fill in the gird to answer the following using formulas only
a.	On Data Set B, fill in columns H-L with the formulas to complete the data
b.	On Question 3, fill in the columns using one of these formulas (Xlookup, Vlookup, Index Match). Add the total for each column.
c.	On Question 3, write a note of which roles are missing from the summary

\begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ A } & B & C & D & E \\ \hline 1 & Role & Total Hours & Total Price & Total Cost & Total Margin \\ \hline 2 & Account Coordinator & & & & \\ \hline 3 & Jr. Account Manager & & & & \\ \hline 4 & Sr. Account Manager & & & & \\ \hline 5 & Associate Account Director & & & & \\ \hline 6 & Account Director & & & & \\ \hline 7 & Sr. Account Director & & & & \\ \hline 8 & Sr. Vice President & & & & \\ \hline 9 & Total & & & & \\ \hline \end{tabular} Note for missing roles in the summary: \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ To Be Completed } & \\ \hline Hourly Margin & Total Hours & Total Price & Total Margin & Total Margin \% \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{1}{|c|}{ A } & B & C & D & E \\ \hline 1 & Role & Total Hours & Total Price & Total Cost & Total Margin \\ \hline 2 & Account Coordinator & & & & \\ \hline 3 & Jr. Account Manager & & & & \\ \hline 4 & Sr. Account Manager & & & & \\ \hline 5 & Associate Account Director & & & & \\ \hline 6 & Account Director & & & & \\ \hline 7 & Sr. Account Director & & & & \\ \hline 8 & Sr. Vice President & & & & \\ \hline 9 & Total & & & & \\ \hline \end{tabular} Note for missing roles in the summary: \begin{tabular}{|l|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ To Be Completed } & \\ \hline Hourly Margin & Total Hours & Total Price & Total Margin & Total Margin \% \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular}