start is 10/1/2019

Butonit Data Table Oftentimes you will receive data that is overly general. Notice in the data table that begins in row 18, daily revenue is provided. However, your analysis calls for monthly and daily aggregation of the revenue data in columns C and D of the data table, use the techniques you leamed above to populate each row with the month and day of the week based on the date in column In column E of the data table, note the target dollar value in cell E16. In column E of the data table, create an If formula that will display TARGET if the revenue in column is greater than or equal to the target value in E16, or MISS otherwise Revenue Pivot Table In cell A2 in Pivot worksheet, create a pivot table based on the data table, that aggregates revenue by placing month in the columns and weekdays in the rows. Make sure Vales in the Pivot Table task one is set to Sum of Revenue What is the lowest sum of revenue in the pivot table? (Note: Conditional formatting can helol) Lowest revenue Month Day $ What is the highest sum of revenue in the pivek table? (Note: Conditional formatting can help!) Highest revenue Month Day Target 52.000 DAY OF WEEK FORMULAS TABLE COLUMNS CE DAY OF WEEK MONTH NA NA NA NA BA NA NA NA INA ENA EUR NA NA NA DATE REVENUE 10/1/2019 10/2/2019 10/3/2016 10/2019 10/5/2019 . 10/6/2010 10/7/2019 10/8/2019 7 9012016 10/10/2010 SO1/2010 10/12/2013 31 10/12019 10/14/2016 10/15/2010 34 1016/2010 25 10/17/2010 10/18/2019 37 10-192010 10/20/2010 1021 2010 40 w2018 102/2010 1/24/2018 41 2018 10/2010 MONTH 52.000 52204 52.023 $3,786 33.533 5281 $1.7 H520 52.200 53.400 33.00 12.00 52.130 51 810 35.110 54350 $2.720 52.923 12.340 52.923 116 12.01 S. 25 NA NA NIA INA INA ENDA TUA UA MA NA NA BA NA Data Pivot + DAY OF WEEK Hit Target? MONTH 3 3 DATE 9 0 1 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 REVENUE 10/1/2019 10/2/2019 10/3/2019 10/4/2019 10/5/2019 10/6/2019 10/7/2019 10/8/2019 10/9/2019 10/10/2019 10/11/2019 10/12/2019 10/13/2019 10/14/2019 10/15/2019 10/16/2019 10/17/2019 10/18/2019 10/19/2019 10/20/2019 10/21/2019 10/22/2019 B Data Pivot MONTH $2,093 $2,204 $2,923 $3,786 $3,533 $2,661 $1,739 $4,528 $2,206 $3,406 $3,656 $2,896 $2,130 $1,810 $3,116 $4.316 $2,720 S3,139 $2,929 $2,340 $3,923 $1.635 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A +