Question: I need help on this question please! Completing this activity will help you learn to: 1. use Excel to determine sales by date, by product,
I need help on this question please!


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: 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-d35bab.x/sx Analyze the sales data in the spreadsheet and enter the answers to the questions for a grade. 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? x 2. What is total sales of t-shirts in April 2021? 3. Which customer purchased the fewest hats in 2021 ? 4. How many invoices did the company issue in 2021 ? 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. 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: 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-d35bab.x/sx Analyze the sales data in the spreadsheet and enter the answers to the questions for a grade. 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? x 2. What is total sales of t-shirts in April 2021? 3. Which customer purchased the fewest hats in 2021 ? 4. How many invoices did the company issue in 2021 ? 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
