Excel Crash Course
Exam from Wall Street
Prep - Wall Street Prep
verified and ( Graded
A+) Questions And
Answers Updated
2026 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 ofthat item?
16
7. Over the entire analysis period, what is the highest
selling item codeby quantity?
16
8. Over the entire analysis period, what is the second
highest sellingitem 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 thehighest 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 item13 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 salesover 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 than700 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 themost 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
2026 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 ofthat item?
16
7. Over the entire analysis period, what is the highest
selling item codeby quantity?
16
8. Over the entire analysis period, what is the second
highest sellingitem 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 thehighest 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 item13 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 salesover 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 than700 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 themost discounts by dollar amount. What
was that amount?
17444.4
