Aggregate sales data resides further below. Each row denotes an individual store. Sales (column L) are sales for the latest month. Goal (column M) is the sales goal for the month. (1) Convert the sales data into a table and name the table TRevenue. (2) Build a formula to calculate the median sales for a selected Districtld. Do all work in the highligted cell below. 2 DistrictID Median Sales (3) Create a formula that counts the number of stores where Sales meet or exceed Goal. Do all work in the highligted cell below. # of Stores that meet or exceed sales goal. (4) Create a formula that counts the number of stores where Sales are less than Goal. Do all work in the highligted cell below. # of Stores that did not meet Sales goal (5) Create a formula that computes the $ amount that sales falls below goal for stores that did not meet goal. Make the result positive. Do all work in the highligted cell below. $ amount that Sales falls below Goal for stores that did not meet goal. Make the result positive. LocationID City Name Territory PostalCode OpenDate SellingAreasize DistrictName Name Chain DM DistrictID - Sales Goal 2 Weirton WV 26032 5/1/2010 40000 FD - District #4 Weirton F Fashions [ Andrew 4 227020 242911.4 3 Beckley WV 25801 2/1/2008 40000 FD - District #2 Beckley F Fashions [ Tina Lassil 2 245508 196406.4 4 Fairmont wy 26554 10/1/2006 15000 FD - District #1 Fairmont | Fashions [ Valery Us! 1 84376.5 86907.8 5 Uniontown PA 15401 10/1/2008 55000 FD - District #4 Uniontow Fashions [ Andrew 4 309815 285029.8 6 Parkersburg WV 26101 8/1/2007 60000 FD - District #2 Parkersbu Fashions (Tina Lassil 2 355278 348172.4 7 Belle Vernon PA 15012 10/1/2007 45000 FD - District #4 Belle Verr Fashions [ Andrew M 4 258246 284070.6 8 Lavale MD 21502 10/1/2008 40000 FD - District #1 Cumberla Fashions (Valery Us! 1 246440 276012.8 9 Clarksburg WV 26330 8/1/2009 40000 FD - District #1 Clarksburg Fashions [ Valery Us! 1 224024 241945.9 10 St. Clairsville OH 43950 4/1/2010 50000 FD - District #4 St. Clairsv Fashions [ Andrew M 4 302850 308907 Aggregate sales data resides further below. Each row denotes an individual store. Sales (column L) are sales for the latest month. Goal (column M) is the sales goal for the month. (1) Convert the sales data into a table and name the table TRevenue. (2) Build a formula to calculate the median sales for a selected Districtld. Do all work in the highligted cell below. 2 DistrictID Median Sales (3) Create a formula that counts the number of stores where Sales meet or exceed Goal. Do all work in the highligted cell below. # of Stores that meet or exceed sales goal. (4) Create a formula that counts the number of stores where Sales are less than Goal. Do all work in the highligted cell below. # of Stores that did not meet Sales goal (5) Create a formula that computes the $ amount that sales falls below goal for stores that did not meet goal. Make the result positive. Do all work in the highligted cell below. $ amount that Sales falls below Goal for stores that did not meet goal. Make the result positive. LocationID City Name Territory PostalCode OpenDate SellingAreasize DistrictName Name Chain DM DistrictID - Sales Goal 2 Weirton WV 26032 5/1/2010 40000 FD - District #4 Weirton F Fashions [ Andrew 4 227020 242911.4 3 Beckley WV 25801 2/1/2008 40000 FD - District #2 Beckley F Fashions [ Tina Lassil 2 245508 196406.4 4 Fairmont wy 26554 10/1/2006 15000 FD - District #1 Fairmont | Fashions [ Valery Us! 1 84376.5 86907.8 5 Uniontown PA 15401 10/1/2008 55000 FD - District #4 Uniontow Fashions [ Andrew 4 309815 285029.8 6 Parkersburg WV 26101 8/1/2007 60000 FD - District #2 Parkersbu Fashions (Tina Lassil 2 355278 348172.4 7 Belle Vernon PA 15012 10/1/2007 45000 FD - District #4 Belle Verr Fashions [ Andrew M 4 258246 284070.6 8 Lavale MD 21502 10/1/2008 40000 FD - District #1 Cumberla Fashions (Valery Us! 1 246440 276012.8 9 Clarksburg WV 26330 8/1/2009 40000 FD - District #1 Clarksburg Fashions [ Valery Us! 1 224024 241945.9 10 St. Clairsville OH 43950 4/1/2010 50000 FD - District #4 St. Clairsv Fashions [ Andrew M 4 302850 308907