Excel Crash Course Exam [Wall Street Prep] - Questions & Answers (98% Success) - Latest Update 2024

5. Over the entire analysis period, which sales rep sold the highest cumulative quantity of a single item? Rob Stewart 6. In the last question you determined the sales person who sold the highest cumulative quantity of a single item. What is the item code of that item? 16 7. Over the entire analysis period, what is the highest selling item code by quantity? 16 8. Over the entire analysis period, what is the second highest selling item code by quantity? 39 9. Only considering postal codes 93372, 93403 and 93434, which postal code had the highest total profit during the month of March? 93372 10. In the last question you determined the postal code that had the highest total profit during the month of March. What was the profit? 13691.4