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$\mathrm{.}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:

ItemUnit priceHats$$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$-$de$7240.$xlsx

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