Open BostonMart Sales and save it as BostonMart Sales (with your name at the end) 1. Create the following plvot table on a new worksheet: a. Notice that the time is in order, Morning, Afternoon, Evening. Cllck and drag within the PivotTable to rearrange. b. Next, in the PivotTable Fields task pane, drag Total Sale from the field list to the Values area in the lowe right to create a second value field c. In the PivotTable Fields task pane, drag the Values out of the Columns area to the Rows area d. Under the Pivot Table Design tab, in the Layout group, click Report Layout and choose Show in Tabular form and rearrange the flelds as necessary to create the following plvot table. o back to the Data sheet and create the following pivot table on a new worksheet: a. Name the sheet tab Q3 b. Display the counts as percentages by right-clicking on any number and choose Show Values As % of Column Total c. Create the following pivot chart from the Pivot Table. Notice the Maximum Bound and Major Units on the chart axis. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what time of day has the lowest Total Sale and at that time of day in which region is the lowest total sale? a. Hint: Sort from Smallest to Largest next to the time of diy and sort from Smallest to Largest next to Region. b. Name the sheet tab Q4 4. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what time of day has the lowest Total Sale and at that time of doy in which region is the lowest total sale? a. Hint Sort from Smallest to Largest next to the time of day and sort from Smallest to Largest next to Region. b. Name the sheet tab Q4 c. Format as shown below 5. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what region has the lowest Totai Sale and in that region what doy had lowest totai sale? a. Hint Sort from Smallest to Largent next to the region and sort from smallest to Largest next to the doy. b. Name the sheet tab QS c. Format as shown below 115&xfx Open BostonMart Sales and save it as BostonMart Sales (with your name at the end) 1. Create the following plvot table on a new worksheet: a. Notice that the time is in order, Morning, Afternoon, Evening. Cllck and drag within the PivotTable to rearrange. b. Next, in the PivotTable Fields task pane, drag Total Sale from the field list to the Values area in the lowe right to create a second value field c. In the PivotTable Fields task pane, drag the Values out of the Columns area to the Rows area d. Under the Pivot Table Design tab, in the Layout group, click Report Layout and choose Show in Tabular form and rearrange the flelds as necessary to create the following plvot table. o back to the Data sheet and create the following pivot table on a new worksheet: a. Name the sheet tab Q3 b. Display the counts as percentages by right-clicking on any number and choose Show Values As % of Column Total c. Create the following pivot chart from the Pivot Table. Notice the Maximum Bound and Major Units on the chart axis. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what time of day has the lowest Total Sale and at that time of day in which region is the lowest total sale? a. Hint: Sort from Smallest to Largest next to the time of diy and sort from Smallest to Largest next to Region. b. Name the sheet tab Q4 4. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what time of day has the lowest Total Sale and at that time of doy in which region is the lowest total sale? a. Hint Sort from Smallest to Largest next to the time of day and sort from Smallest to Largest next to Region. b. Name the sheet tab Q4 c. Format as shown below 5. Go back to the Data sheet and create a pivot table on a new worksheet to answer the following question, what region has the lowest Totai Sale and in that region what doy had lowest totai sale? a. Hint Sort from Smallest to Largent next to the region and sort from smallest to Largest next to the doy. b. Name the sheet tab QS c. Format as shown below 115&xfx
