Excel Crash Course Ex u u u
am from Wall StreetPre
u u u u
p- u
Wall Street Prepverifie
u u u u
d and ( Graded A+) Ques
u u u u u
tions And Answers Upd
u u u
ated 2022 Quaranteed
u u u
100% Score. u
, Rob Stewart u
6. In the last question you determined the sales person
u u u u u u u u u
who sold the highest cumulative quantity of a singleit
u u u u u u u u u
em. What is the item code ofthat item?
u u u u u u u
16
7. Over the entire analysis period, what is the highests
u u u u u u u u u
elling item codeby quantity?
u u u
16
8. Over the entire analysis period, what is the second
u u u u u u u u u
highest sellingitem code by quantity?
u u u u
39
9. Onlyuconsideringu postalu codesu 93372,u 93403u andu934
34, which postal code had the highest total profitduri
u u u u u u u u u
ng the month of March?93372
u u u u
, 10. Inu theu lastu questionu youu determinedu theu postalu codeut
hat had thehighest total profit during the month of Marc
u u u u u u u u u
h. What was the profit? 13691.4
u u u u u
11. DuringutheumonthuofuApril,uwhichupostalucodeuboughtut
he most of item13 by quantity?
u u u u u
93558
12. Inutheulastuquestion,uyouudeterminedutheupostalucodeutha
t bought the most of item 13 by quantity for the month of
u u u u u u u u u u u u u
April. What was that quantity?
u u u u
24
13. WhatuisutheutotaluofuAmyuAdam’susalesuoverutheua
nalysis period?492,153.8 u
14. Inutheupreviousuquestion,uyouudeterminedutheutheutotaluo
f Amy’s salesover the analysis period. What was hertotal
u u u u u u u u u u
profit?
255,548.1
15. Duringutheuthree-
month period of January through March, what was the
u u u u u u u u u
quantity of item 23 sold whileFred Rubble was the Ma
u u u u u u u u u u
nager on duty? u u
784
16. DuringutheumonthuofuMay,uhowumanyupostalucodesub
ought more than700 products by quantity?
u u u u u
4
17. Overutheuentireuanalysisuperiod,uwhichusalesurepugaveuth
e most discounts by dollar amount? Enter the name as: F
u u u u u u u u u u
irstnameLastname.Oliver Winslow u
18. Inu theu previousu question,u youu determinedu whichu salesur
ep gave themost discounts by dollar amount. What was
u u u u u u u u
that amount?
u u
am from Wall StreetPre
u u u u
p- u
Wall Street Prepverifie
u u u u
d and ( Graded A+) Ques
u u u u u
tions And Answers Upd
u u u
ated 2022 Quaranteed
u u u
100% Score. u
, Rob Stewart u
6. In the last question you determined the sales person
u u u u u u u u u
who sold the highest cumulative quantity of a singleit
u u u u u u u u u
em. What is the item code ofthat item?
u u u u u u u
16
7. Over the entire analysis period, what is the highests
u u u u u u u u u
elling item codeby quantity?
u u u
16
8. Over the entire analysis period, what is the second
u u u u u u u u u
highest sellingitem code by quantity?
u u u u
39
9. Onlyuconsideringu postalu codesu 93372,u 93403u andu934
34, which postal code had the highest total profitduri
u u u u u u u u u
ng the month of March?93372
u u u u
, 10. Inu theu lastu questionu youu determinedu theu postalu codeut
hat had thehighest total profit during the month of Marc
u u u u u u u u u
h. What was the profit? 13691.4
u u u u u
11. DuringutheumonthuofuApril,uwhichupostalucodeuboughtut
he most of item13 by quantity?
u u u u u
93558
12. Inutheulastuquestion,uyouudeterminedutheupostalucodeutha
t bought the most of item 13 by quantity for the month of
u u u u u u u u u u u u u
April. What was that quantity?
u u u u
24
13. WhatuisutheutotaluofuAmyuAdam’susalesuoverutheua
nalysis period?492,153.8 u
14. Inutheupreviousuquestion,uyouudeterminedutheutheutotaluo
f Amy’s salesover the analysis period. What was hertotal
u u u u u u u u u u
profit?
255,548.1
15. Duringutheuthree-
month period of January through March, what was the
u u u u u u u u u
quantity of item 23 sold whileFred Rubble was the Ma
u u u u u u u u u u
nager on duty? u u
784
16. DuringutheumonthuofuMay,uhowumanyupostalucodesub
ought more than700 products by quantity?
u u u u u
4
17. Overutheuentireuanalysisuperiod,uwhichusalesurepugaveuth
e most discounts by dollar amount? Enter the name as: F
u u u u u u u u u u
irstnameLastname.Oliver Winslow u
18. Inu theu previousu question,u youu determinedu whichu salesur
ep gave themost discounts by dollar amount. What was
u u u u u u u u
that amount?
u u
