Please show the steps in excel, using table references, that are required to build this model.

4 A E F G H 1 Build a model that populates the table below. Assume that transactions may be added or deleted from the 2 list and the data about the transactions may change; the table should update in response to these changes. 3 NOTE: You must use table references (with square brackets) and not named ranges. 4 Hint: Before you insert a table, add the needed calculation column(s) to the input list. 5 6 Maximum sales of makeup products (excluding returns) by quarter 7 1 2 3 8 Q1 Q2 Q3 04 9 eye liner 10 foundation 11 lip gloss 12 lipstick 13 mascara 14 Note: For this problem ASSUME that the input data may change: rows may be added or 15 deleted. DO NOT ADD OR DELETE ANY INPUT ROWS, THOUGH. 16 Do not delete input data 17 Trans Nur Name Date Product Units Dollars 18 1 Betsy 5/1/2018 lip gloss 45 $137.20 19 2 Hallagan 4/10/2018 foundatio 50 $152.01 20 3 Ashley 3/25/2019 lipstick 9 $ 28.72 21 4 Hallagan 6/22/2020 lip gloss 55 $167.08 22 5 Zaret 7/17/2018 lip gloss 43 $130.60 23 6 Colleen 12/27/2019 eye liner 58 $175.99 24 7 Cristina 4/21/2018 eye liner 8 $ 25.80 25 8 Colleen 1/17/2021 lip gloss 72 $217.84 26 9 Ashley 8/5/2020 eye liner 75 $226.64 27 10 Betsy 9/7/2020 lip gloss 24 $ 73.50 28 11 Ashley 12/29/2018 mascara 43 $130.84 29 12 Ashley 12/18/2018 lip gloss 23 $ 71.03 30 13 Emilee 10/1/2019 lip gloss 49 $149.59 31 14 Hallagan 2/1/2019 eye liner 18 $ 56.47 32 15 Zaret 10/20/2020 foundatio -8 $ (21.99) 33 16 Emilee 5/12/2018 mascara 45 $137.39 34 17 Colleen 5/30/2020 mascara 66 $199.65 35 18 Jen 10/1/2019 lip gloss 88 $265.19 36 19 Jen 11/27/2018 eye liner 78 $236.15 37 20 Zaret 12/27/2019 lip gloss 57 $173.12 4 A E F G H 1 Build a model that populates the table below. Assume that transactions may be added or deleted from the 2 list and the data about the transactions may change; the table should update in response to these changes. 3 NOTE: You must use table references (with square brackets) and not named ranges. 4 Hint: Before you insert a table, add the needed calculation column(s) to the input list. 5 6 Maximum sales of makeup products (excluding returns) by quarter 7 1 2 3 8 Q1 Q2 Q3 04 9 eye liner 10 foundation 11 lip gloss 12 lipstick 13 mascara 14 Note: For this problem ASSUME that the input data may change: rows may be added or 15 deleted. DO NOT ADD OR DELETE ANY INPUT ROWS, THOUGH. 16 Do not delete input data 17 Trans Nur Name Date Product Units Dollars 18 1 Betsy 5/1/2018 lip gloss 45 $137.20 19 2 Hallagan 4/10/2018 foundatio 50 $152.01 20 3 Ashley 3/25/2019 lipstick 9 $ 28.72 21 4 Hallagan 6/22/2020 lip gloss 55 $167.08 22 5 Zaret 7/17/2018 lip gloss 43 $130.60 23 6 Colleen 12/27/2019 eye liner 58 $175.99 24 7 Cristina 4/21/2018 eye liner 8 $ 25.80 25 8 Colleen 1/17/2021 lip gloss 72 $217.84 26 9 Ashley 8/5/2020 eye liner 75 $226.64 27 10 Betsy 9/7/2020 lip gloss 24 $ 73.50 28 11 Ashley 12/29/2018 mascara 43 $130.84 29 12 Ashley 12/18/2018 lip gloss 23 $ 71.03 30 13 Emilee 10/1/2019 lip gloss 49 $149.59 31 14 Hallagan 2/1/2019 eye liner 18 $ 56.47 32 15 Zaret 10/20/2020 foundatio -8 $ (21.99) 33 16 Emilee 5/12/2018 mascara 45 $137.39 34 17 Colleen 5/30/2020 mascara 66 $199.65 35 18 Jen 10/1/2019 lip gloss 88 $265.19 36 19 Jen 11/27/2018 eye liner 78 $236.15 37 20 Zaret 12/27/2019 lip gloss 57 $173.12