3 Create an advanced filter to find all purchases in the table that take place

3 create an advanced filter to find all purchases in

This preview shows page 1 - 2 out of 2 pages.

3Create an advanced filter to find all purchases in the table that take place after September 30, 2018. 4 In cell D4, use the SUBTOTAL function to calculate the average number of Halloween costumes sold. Format with 0 decimals. 5 In cell D5, use the SUBTOTAL function to calculate the total number of Christmas costumes sold. Format with 0 decimals. 6Using the data table, create a PivotTable on a new worksheet. Drag Date to the Rows area. Drag Halloween and Christmas to the Values area. Extra step for PC only (not Mac): Right click on cell A4 and select Ungroup.4.0007Rename the PivotTable worksheet to PivotTable Analysis. Rename the label in cell A3 as Date. Cells B3 and C3 should display as the Sum of Halloween and Sum of Christmas.6.0008Rename cells B3 and C3 as Halloween Costumesand Christmas Costumes2.0009Apply Pivot Style Light 1 and Banded Rows formatting.3.000Insert a slicer for the Date field. Apply Slicer Style Other 1 (in the Light section), format the slicer with 3 columns, and then resize and move the slicer so it covers range E1:I33. In the slicer, select all dates from 11/1/2018 through 11/30/2018 (Hint: Use the SHIFT key to extend a selection). 10
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture