Use the table beginning in row 24 to answer the questions below: You will need the function SUMIF to solve. max10 points \begin{tabular}{l|l|l|} \hline \multicolumn{1}{|c|}{ Product } & Total Revenue & Units \\ \cline { 2 - 3 } ip gloss & & \\ \hline Foundation & & \\ \hline ipstick & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Total Revenue tarned before December 10, 2005 see the Panopto on COUNT functions for the clue on how to write this condition. Total Units sold by salespeople whose last name begin with C. see the Panopto on COUNT functions for the clue on how to write this condition. Total Revenue earned by people who have five letters in their name. see the Panopto on COUNT functions for the clue on how to write this condition. How many units were sold by people other than Colleen. see the Panopto on COUNT functions for the clue on how to write this condition. Use the table beginning in row 24 to answer the questions below: You will need the function SUMIF to solve. max10 points \begin{tabular}{l|l|l|} \hline \multicolumn{1}{|c|}{ Product } & Total Revenue & Units \\ \cline { 2 - 3 } ip gloss & & \\ \hline Foundation & & \\ \hline ipstick & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} Total Revenue tarned before December 10, 2005 see the Panopto on COUNT functions for the clue on how to write this condition. Total Units sold by salespeople whose last name begin with C. see the Panopto on COUNT functions for the clue on how to write this condition. Total Revenue earned by people who have five letters in their name. see the Panopto on COUNT functions for the clue on how to write this condition. How many units were sold by people other than Colleen. see the Panopto on COUNT functions for the clue on how to write this condition