Use the JuiceLand worksheet. Insert a PivotTable for data in A3:E61, placing the report on a new worksheet. Re-name that new worksheet JuicePivot or something similar. Re-create the same three summary tables (Count of Sales, Total Sales, and Average Sales) as in Question #3 (but this time you can use the drag & drop PivotTables rather than functions). Change the Pivot Report Layout to Outline or Tabular form. As with #3, cells displaying sales amounts should have appropriate formatting for financial values and some indication of units. Cells that do not contain financial values should display no decimal places.

Juiceland Male Female Total Transaction Smoothie Type 1 Berry 2 Berry 3 Green 4. Protein 5 Protein 6 Berry Count of Sales Morning Afternoon Night Total Male Female Total 7 8 9 10 Green Green Protein Berry Protein Total Sales Morning Afternoon Night Total 11 Protein Berry 12 13 14 15 16 Male Female Average Average Sales Morning Afternoon Night Average 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Green Green Protein Berry Green Green Protein Berry Green Green Protein Berry Berry Green Protein Green Green Green Protein Protein Berry Green Green Protein Green Green Protein Berry Berry Green Green Protein Berry Green Protein Protein Green Green Green Protein Protein Berry Berry Green Protein Price Gender $ 7.95 Female $ 7.95 Female $ 8.95 Female $9.95 Female $9.95 Male $ 7.95 Male $ 8.95 Female $ 8.95 Female $ $9.95 Male $ 7.95 Male $9.95 Female $ 9.95 Male $ 7.95 Male $ 8.95 Female $ 8.95 Female $9.95 Male $ 7.95 Male $ 8.95 Male $ 8.95 Male $9.95 Female $ 7.95 Male $ 8.95 Female $ 8.95 Female $9.95 Male $ 7.95 Male $ 7.95 Female $ 8.95 Female $9.95 Male $ 8.95 Male $ 8.95 Female $ 8.95 Male $9.95 Female $9.95 Female $ 7.95 Female $ 8.95 Male $ 8.95 Female $9.95 Male $ 8.95 Female $ 8.95 Male $9.95 Male $ 7.95 Female $ 7.95 Female $ 8.95 Male $ 8.95 Female $9.95 Male $ 7.95 Male $ 8.95 Female $9.95 Male $9.95 Female $ 8.95 Male $ 8.95 Female $ 8.95 Male $9.95 $9.95 Female $ 7.95 Female $ 7.95 Male $ 8.95 Female $9.95 Male Shift 2 - Afternoon 1 - Morning 3 - Night 1 - Morning 3 - Night 1 - Morning 2 - Afternoon 2 - Afternoon 3 - Night 2 - Afternoon 2 - Afternoon 3 - Night 2 - Afternoon 2 - Afternoon 3 - Night 3 - Night 1 - Morning 2 - Afternoon 3 - Night 3 - Night 2 - Afternoon 3 - Night 3 - Night 2 - Afternoon 2 - Afternoon 1 - Morning 2 - Afternoon 3 - Night 2 - Afternoon 3 - Night 2 - Afternoon 3 - Night 3 - Night 3 - Night 2 - Afternoon 2 - Afternoon 3 - Night 1 - Morning 1 - Morning 2 - Afternoon 2 - Afternoon 2 - Afternoon 1 - Morning 3 - Night 3 - Night 1 - Morning 3 - Night 1 - Moming 3 - Night 1 - Morning 3 - Night 3 - Night 1 - Moming 1 - Morning 2 - Afternoon 2 - Afternoon 1 - Morning 3 - Night Female