100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Excel Crash Course Exam from Wall Street Prep - Wall Street Prep verified and ( Graded A+) Questions And Answers Updated 2022 Quaranteed 100% Score. Rob Stewar $17.99   Add to cart

Exam (elaborations)

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep verified and ( Graded A+) Questions And Answers Updated 2022 Quaranteed 100% Score. Rob Stewar

 0 view  0 purchase
  • Course
  • Excel Crash Course
  • Institution
  • Excel Crash Course

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep verified and ( Graded A+) Questions And Answers Updated 2022 Quaranteed 100% Score. Rob Stewart 6. In the last question you determined the sales person who sold the highest cumulative quantity of a single item. What ...

[Show more]

Preview 3 out of 24  pages

  • January 25, 2024
  • 24
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers
  • excel crash course
  • Excel Crash Course
  • Excel Crash Course
avatar-seller
joycewanjiku0036
Excel Crash Course
Exam from Wall Street
Prep - Wall Street Prep
verified and ( Graded
A+) Questions And
Answers Updated
2022 Quaranteed
100% Score.

, 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


11. During the month of April, which postal code bought
the most of item 13 by quantity?
93558

12. In the last question, you determined the postal code
that bought the most of item 13 by quantity for the
month of April. What was that quantity?
24

13. What is the total of Amy Adam’s sales over the
analysis period? 492,153.8

14. In the previous question, you determined the the total
of Amy’s sales over the analysis period. What was her
total profit?
255,548.1

15. During the three-month period of January through
March, what was the quantity of item 23 sold while
Fred Rubble was the Manager on duty?
784

16. During the month of May, how many postal codes
bought more than 700 products by quantity?
4

17. Over the entire analysis period, which sales rep gave
the most discounts by dollar amount? Enter the name
as: FirstnameLastname. Oliver Winslow

18. In the previous question, you determined which sales
rep gave the most discounts by dollar amount. What
was that amount?
17444.4

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller joycewanjiku0036. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $17.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

79223 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$17.99
  • (0)
  Add to cart