Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an advanced filter to find all purchases in the table that take place after September 30, 2015 ( >9/30/2015 ). Enter the appropriate criteria
Create an advanced filter to find all purchases in the table that take place after September 30, 2015 (>9/30/2015). Enter the appropriate criteria in cell A2 and filter the data in-place.
In cell D4, use theSUBTOTALfunction to calculate the average number ofHalloweencostumes sold. Format with 0 decimals.
In cell D5, use theSUBTOTALfunction to calculate the total number ofChristmascostumes sold. Format with 0 decimals.
\f[I Insert Column or Bar Chart V 6 K37 v E X \\/ f3: 0 I 2 I 3 Date Column1 Stars Stripes 23 9/16/2015 1 1 29 9/17/2015 3 3 30 9/13/2015 2 2 31 9/19/2015 1 1 32 9/20/2015 4 4 33 9/21/2015 6 6 34 9/22/2015 1 1 35 9/23/2015 1 1 36 9/24/2015 0 0 37 9/25/2015 0 0 33 9/26/2015 0 0 39 9/27/2015 0 0 40 9/23/2015 0 0 41 9/29/2015 0 0 42 9/30/2015 2 2 43 10/1/2015 4 4 44 10/2/2015 2 2 45 10/3/2015 2 2 46 10/4/2015 E 3 3 4 > Sales Data Pricing| BreakEvenAnalysis
Create an advanced filter to find all purchases in the table that take place after September 30, 2015 (>9/30/2015). Enter the appropriate criteria in cell A2 and filter the data in-place. |
In cell D4, use theSUBTOTALfunction to calculate the average number ofHalloweencostumes sold. Format with 0 decimals. |
In cell D5, use theSUBTOTALfunction to calculate the total number ofChristmascostumes sold. Format with 0 decimals. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started