Please show me the formulas used to solve each question.

B E D F 1 Use the table beginning in row 22 to answer the questions below: 2 3 Product Total Revenue Units 4 lip gloss 5 foundation 6 lipstick 7 eye liner 8 mascara 9 10 Total Revenve earned before December 10, 2005 11 12 13 Total Units sold by saledpeople whose last name begin with C. 14 15 16 Total Revenve earned by people who have five letters in their name. 17 18 19 How many units were sold by people other than Colleen. 20 21 22 Trans Name Date Product Units Revenue 23 1 Betsy 4/1/2004 lip gloss 45 $ 137.20 24 2 Hallagan 3/10/2004 foundation 50 $ 152.01 25 3 Ashley 2/25/2005 lipstick 9 $ 28.72 26 4 Hallagan 5/22/2006 lip gloss 55 $ 167.08 27 5 Zaret 6/17/2004 lip gloss 43 S 130.60 28 6 Colleen 11/27/2005 eye liner 58 $ 175.99 29 7 Cristina 3/21/2004 eye liner 8 $ 25.80 30 8 Colleen 12/17/2006 lip gloss 72 $ 217.84 31 9 Ashley 7/5/2006 eye liner 75 S 226.64 32 10 Betsy 8/7/2006 lip gloss 24 S 73.50