Business Analyst Excel Questions:

Exercise 1: Quantitative Questions ( What would be the formulas on Excel )

Using the data provided, please answer the following questions:

1. What is the total quantity of product CK-M-20015 ordered in January 2020?

2. How many orders were placed on Jan 16, 2020?

3. How many unique customers ordered Math Curriculum Kits (Product Category = Curriculum Kit and Product Subject = Math) in March 2020?

4. In 2020 Q1, what were the top-three Teacher Guides in terms of quantity ordered?

5. Based on all available order data, what were the top-three states to which products shipped, in terms of numbers of unique orders placed?

6. Days to Fulfill is defined as the number of days between the date an order is placed and the date an order is delivered. Based on all available order data, which Ship to State(s) have an average Days to Fulfill between 4 and 5?

7. Some orders have not yet been delivered. Given the data provided, which customer has been waiting the longest from the time that their order was placed?

8. What is the total quantity of product: Language Arts Student Workbook - Grade 4 (Set Of 25) that has been ordered, but not yet delivered, from January-March?