Data Cells are from C20:H1919

Please help me figure this out.

ot delete input data THIS IS NOT THE SAME AS HW3. Build a model that populates the table below. Assume that transactions may be added or deleted from the list and the data about the transactions may change; the table should update in response to these changes. NOTE: You must use table references (with square brackets) and not named ranges. Hint: Before you insert a table, add the needed calculation column(s) to the input list. Maximum sales of makeup products (excluding returns) by quarter 1 2 3 01 02 Q3 04 eye liner foundation lip gloss lipstick mascara Note: For this problem ASSUME that the input data may change: rows may be added or deleted. DO NOT ADD OR DELET Trans Nur Name 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan S.Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley Rati Rest 22 Date Product Units 5/1/2018 lip gloss 4/10/2018 Foundatio 3/25/2019 lipstick 6/22/2020 lip gloss 7/17/2018 tip gloss 12/27/2019 eyeliner 4/21/2018 eye liner 1/17/2001 p gloss 8/5/2020 eyeliner //allinto pa Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 S 167.08 43 S 130.60 58 $ 175.99 8 5 25:80 72 $ 27.84 35 $ 226,64 4 ot delete input data THIS IS NOT THE SAME AS HW3. Build a model that populates the table below. Assume that transactions may be added or deleted from the list and the data about the transactions may change; the table should update in response to these changes. NOTE: You must use table references (with square brackets) and not named ranges. Hint: Before you insert a table, add the needed calculation column(s) to the input list. Maximum sales of makeup products (excluding returns) by quarter 1 2 3 01 02 Q3 04 eye liner foundation lip gloss lipstick mascara Note: For this problem ASSUME that the input data may change: rows may be added or deleted. DO NOT ADD OR DELET Trans Nur Name 1 Betsy 2 Hallagan 3 Ashley 4 Hallagan S.Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley Rati Rest 22 Date Product Units 5/1/2018 lip gloss 4/10/2018 Foundatio 3/25/2019 lipstick 6/22/2020 lip gloss 7/17/2018 tip gloss 12/27/2019 eyeliner 4/21/2018 eye liner 1/17/2001 p gloss 8/5/2020 eyeliner //allinto pa Dollars 45 $137.20 50 $ 152.01 9 $ 28.72 55 S 167.08 43 S 130.60 58 $ 175.99 8 5 25:80 72 $ 27.84 35 $ 226,64 4