Open the spreadsheet Excel_7. Create a pivot table using the data on the Pivot Table Data sheet. The pivot table should show monthly sales based on type of sale. Greate a new tab and name it Goal-Seek. On this sheet in the spreadsheet, create a goal seek what-if analysis for Tolkien's Books District 1 store sales in April. The sales for the first three weeks are: Weok 1:$6,578 Weok 2: $5,679 Weok 3: $4,980 Find the sales needed in week 4 that will give average sales for the month of $6,000. Create a new tab and name it Scenario. On this sheet in the spreadsheet, create a Scenario for District 2 store sales in April. Create your own figures for a Target Case, Best Case, and Worst Case scenario for the four weeks in April