Completing this activity will help you learn to:

1.	use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof.
2.	explain what can be accomplished when analyzing data.

Case Scenario: You are working at a startup that sells university merchandise online.

The business sells three products, as follows:

Item	Unit price
Hats	$10
T-shirts	15
Sweatshirts	30

The business sells wholesale to six customers: Atlanta, Dakota, Madrid, Orlando, Phoenix, and Venice companies.

To help plan for the next year, you must analyze sales from this past year. Sales data is captured in the attached excel file.

Required: