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
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
