D E F H K L M N o B 1 30 pts. 2 Do not delete input data 3 4 5 nmin ON 09 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 4 1 Q1 2 Q2 3 Q3 Q4 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 DELETE ANY INPUT ROWS, THOUGH. Trans Numbe 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Name Date Produc Units 1 Betsy 5/1/2018 lip gloss 2 Hallagan 4/10/2018 foundation 3 Ashley 3/25/2019 lipstick 4 Hallagan 6/22/2020 lip gloss 5 Zaret 7/17/2018 lip gloss 6 Colleen 12/27/2019 eye liner 7 Cristina 4/21/2018 eye liner 8 Colleen 1/17/2021 lip gloss 9 Ashley 8/5/2020 eye liner 10 Betsy 9/7/2020 lip gloss 11 Ashley 12/29/2018 mascara 12 Ashley 12/18/2018 lip gloss 13 Emilee 10/1/2019 lip gloss 14 Hallagan 2/1/2019 eye liner 15 Zaret 10/20/2020 foundation 16 Emilee 5/12/2018 mascara 17 Colleen 5/30/2020 mascara 18 Jen 10/1/2019 lip gloss 19 Jen 11/27/2018 eye liner 20 Zaret 12/27/2019 lip gloss 21 Zaret 7/2/2020 mascara 22 Betsy 10/24/2018 eye liner 23 Colleen 3/1/2020 mascara 24 Hallagan 6/2/2019 foundation 25 Jen 12/7/2018 mascara 26 Emilee 1/6/2021 in class Dollars 45 $ 137.20 50 $ 152.01 9 $ 28.72 55 $ 167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $ 199.65 88 $ 265.19 78 $ 236.15 57 $ 173.12 12 $ 38,08 28 $ 86.51 25 $77.31 29 $ 88.22 -4 S (9.94) 24 $74 62 D E F H K L M N o B 1 30 pts. 2 Do not delete input data 3 4 5 nmin ON 09 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 4 1 Q1 2 Q2 3 Q3 Q4 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 DELETE ANY INPUT ROWS, THOUGH. Trans Numbe 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Name Date Produc Units 1 Betsy 5/1/2018 lip gloss 2 Hallagan 4/10/2018 foundation 3 Ashley 3/25/2019 lipstick 4 Hallagan 6/22/2020 lip gloss 5 Zaret 7/17/2018 lip gloss 6 Colleen 12/27/2019 eye liner 7 Cristina 4/21/2018 eye liner 8 Colleen 1/17/2021 lip gloss 9 Ashley 8/5/2020 eye liner 10 Betsy 9/7/2020 lip gloss 11 Ashley 12/29/2018 mascara 12 Ashley 12/18/2018 lip gloss 13 Emilee 10/1/2019 lip gloss 14 Hallagan 2/1/2019 eye liner 15 Zaret 10/20/2020 foundation 16 Emilee 5/12/2018 mascara 17 Colleen 5/30/2020 mascara 18 Jen 10/1/2019 lip gloss 19 Jen 11/27/2018 eye liner 20 Zaret 12/27/2019 lip gloss 21 Zaret 7/2/2020 mascara 22 Betsy 10/24/2018 eye liner 23 Colleen 3/1/2020 mascara 24 Hallagan 6/2/2019 foundation 25 Jen 12/7/2018 mascara 26 Emilee 1/6/2021 in class Dollars 45 $ 137.20 50 $ 152.01 9 $ 28.72 55 $ 167.08 43 $ 130.60 58 $ 175.99 8 $ 25.80 72 $ 217.84 75 $ 226.64 24 $ 73.50 43 $ 130.84 23 $ 71.03 49 $ 149.59 18 $ 56.47 -8 $ (21.99) 45 $ 137.39 66 $ 199.65 88 $ 265.19 78 $ 236.15 57 $ 173.12 12 $ 38,08 28 $ 86.51 25 $77.31 29 $ 88.22 -4 S (9.94) 24 $74 62
