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:

Download spreadsheet CaseSalesData-092f5a.xlsx

Analyze the sales data in the spreadsheet and enter the answers to the questions for a grade.

HINT: STEP-BY-STEP WALKTHROUGH

1. What is the total number of sweatshirts sold in 2021? fill in the blank 2

2. What is total sales of t-shirts in April 2021? fill in the blank 3

3. Which customer purchased the fewest hats in 2021?

Atlanta

Dakota

Madrid

Orlando

Phoenix

Venice

Madrid

4. How many invoices did the company issue in 2021? fill in the blank 5

5. Explain what can be accomplished by analyzing this sales data.

The input in the box below will not be graded, but may be reviewed and considered by your instructor.