Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fraud Data Analytics Methodology

Authors: Leonard W Vona

1st Edition

111918679X, 9781119186793

More Books

Students also viewed these Accounting questions