Excel Crash Course Exam from Wall
s s s s s
Street Prep - Wall Street Prep Questions
s s s s s s
And Answers Updated 2024
s s s
Instructions:sQuestionss1-4susesthesfinancialsmodelsonstabsQ1-
4sinsthesExamsWorkbook.sCompletesthesmodelsbysfillingsinsthesblankscellss
beforesansweringsthesquestionsbelow.sAnswerssshouldsbesroundedstosthesn
earestswholesnumber,scommasseparatings000s,sNOTswrittensinscurrencysf
ormat.sSosifsthesanswersiss$5,505,210.50,syouswouldsinputs5,505,210.
1. WhatsissforecastsRevenuesins2017?s13,642,021
2. WhatsissforecastsNetsIncomesins2016?s925,777
3. Ifs Depreciation&Amortizations ass as %s ofs Capitals Expendituress issc
hangedstos30%,swhatsissNetsIncomesins2017?s1,123,438
4. WhatsissthesEBITDAs%sMarginsins2018?s17.1%
Instructions:sQuestionss5-19susesthesdatastablesonstabsQ5-
19sinsthesExamsWorkbook.sWesstronglysrecommendsyousanalyzesthissdata
swithsthesaidsofsaspivotstable.sYousmaysalsosbenefitsfromsaddingssomesext
rascalculationscolumnsstosthesdataset.sAnswerssforsnumericalsdatasshould
sbesroundedstosthesnearests1sdecimal,scommasseparatings000s,sNOTswrit
tensinscurrencysformat.sSosifsthesanswersiss$10,500.658,syouswouldsinputs1
0,500.7.
5. Overs thes entires analysiss period,s whichs saless reps solds thes highests cu
mulativesquantitysofsassinglesitem?sRobsStewart
6. Instheslastsquestionsyousdeterminedsthessalesspersonswhossoldstheshigh
estscumulativesquantitysofsassinglesitem.sWhatsissthesitemscodesofsthatsit
em?
16
7. Oversthesentiresanalysissperiod,swhatsissthessecondshighestssellingsitems
codesbysquantity?
39
8. Oversthesentiresanalysissperiod,swhatsisstheshighestssellingsitemscodesby
squantity?
16
9. Onlysconsideringspostalscodess93372,s93403sands93434,swhichspostals
codeshadstheshigheststotalsprofitsduringsthesmonthsofsMarch?s93372
, 10. Instheslastsquestionsyousdeterminedsthespostalscodesthatshadstheshighestst
otalsprofitsduringsthesmonthsofsMarch.sWhatswassthesprofit?
13691.4
11. DuringsthesmonthsofsApril,swhichspostalscodesboughtsthesmostsofsitems1
3sbysquantity?
93558
12. Instheslastsquestion,syousdeterminedsthespostalscodesthatsboughtsthesmo
stsofsitems13sbysquantitysforsthesmonthsofsApril.sWhatswassthatsquantity?
24
13. Whats iss thes totals ofs Amys Adam’ss saless overs thes analysiss period?s 49
2,153.8
14. Insthesprevioussquestion,syousdeterminedsthesthestotalsofsAmy’sssalesso
versthesanalysissperiod.sWhatswassherstotalsprofit?
255,548.1
15. Duringsthesthree-
monthsperiodsofsJanuarysthroughsMarch,swhatswassthesquantitysofsitems2
3ssoldswhilesFredsRubbleswassthesManagersonsduty?s784
16. DuringsthesmonthsofsMay,showsmanyspostalscodessboughtsmoresthans70
0sproductssbysquantity?
4
17. Oversthesentiresanalysissperiod,swhichssalessrepsgavesthesmostsdiscoun
tssbysdollarsamount?sEntersthesnamesas:sFirstnameLastname.sOliversW
inslow
18. Insthesprevioussquestion,syousdeterminedswhichssalessrepsgavesthesmo
stsdiscountssbysdollarsamount.sWhatswassthatsamount?s17444.4
19. Oversthesentiresanalysissperiod,swhichsitemscodesdidspostalscodes93930s
spendsthesgreatestsdollarsson?s16
20.
s s s s s
Street Prep - Wall Street Prep Questions
s s s s s s
And Answers Updated 2024
s s s
Instructions:sQuestionss1-4susesthesfinancialsmodelsonstabsQ1-
4sinsthesExamsWorkbook.sCompletesthesmodelsbysfillingsinsthesblankscellss
beforesansweringsthesquestionsbelow.sAnswerssshouldsbesroundedstosthesn
earestswholesnumber,scommasseparatings000s,sNOTswrittensinscurrencysf
ormat.sSosifsthesanswersiss$5,505,210.50,syouswouldsinputs5,505,210.
1. WhatsissforecastsRevenuesins2017?s13,642,021
2. WhatsissforecastsNetsIncomesins2016?s925,777
3. Ifs Depreciation&Amortizations ass as %s ofs Capitals Expendituress issc
hangedstos30%,swhatsissNetsIncomesins2017?s1,123,438
4. WhatsissthesEBITDAs%sMarginsins2018?s17.1%
Instructions:sQuestionss5-19susesthesdatastablesonstabsQ5-
19sinsthesExamsWorkbook.sWesstronglysrecommendsyousanalyzesthissdata
swithsthesaidsofsaspivotstable.sYousmaysalsosbenefitsfromsaddingssomesext
rascalculationscolumnsstosthesdataset.sAnswerssforsnumericalsdatasshould
sbesroundedstosthesnearests1sdecimal,scommasseparatings000s,sNOTswrit
tensinscurrencysformat.sSosifsthesanswersiss$10,500.658,syouswouldsinputs1
0,500.7.
5. Overs thes entires analysiss period,s whichs saless reps solds thes highests cu
mulativesquantitysofsassinglesitem?sRobsStewart
6. Instheslastsquestionsyousdeterminedsthessalesspersonswhossoldstheshigh
estscumulativesquantitysofsassinglesitem.sWhatsissthesitemscodesofsthatsit
em?
16
7. Oversthesentiresanalysissperiod,swhatsissthessecondshighestssellingsitems
codesbysquantity?
39
8. Oversthesentiresanalysissperiod,swhatsisstheshighestssellingsitemscodesby
squantity?
16
9. Onlysconsideringspostalscodess93372,s93403sands93434,swhichspostals
codeshadstheshigheststotalsprofitsduringsthesmonthsofsMarch?s93372
, 10. Instheslastsquestionsyousdeterminedsthespostalscodesthatshadstheshighestst
otalsprofitsduringsthesmonthsofsMarch.sWhatswassthesprofit?
13691.4
11. DuringsthesmonthsofsApril,swhichspostalscodesboughtsthesmostsofsitems1
3sbysquantity?
93558
12. Instheslastsquestion,syousdeterminedsthespostalscodesthatsboughtsthesmo
stsofsitems13sbysquantitysforsthesmonthsofsApril.sWhatswassthatsquantity?
24
13. Whats iss thes totals ofs Amys Adam’ss saless overs thes analysiss period?s 49
2,153.8
14. Insthesprevioussquestion,syousdeterminedsthesthestotalsofsAmy’sssalesso
versthesanalysissperiod.sWhatswassherstotalsprofit?
255,548.1
15. Duringsthesthree-
monthsperiodsofsJanuarysthroughsMarch,swhatswassthesquantitysofsitems2
3ssoldswhilesFredsRubbleswassthesManagersonsduty?s784
16. DuringsthesmonthsofsMay,showsmanyspostalscodessboughtsmoresthans70
0sproductssbysquantity?
4
17. Oversthesentiresanalysissperiod,swhichssalessrepsgavesthesmostsdiscoun
tssbysdollarsamount?sEntersthesnamesas:sFirstnameLastname.sOliversW
inslow
18. Insthesprevioussquestion,syousdeterminedswhichssalessrepsgavesthesmo
stsdiscountssbysdollarsamount.sWhatswassthatsamount?s17444.4
19. Oversthesentiresanalysissperiod,swhichsitemscodesdidspostalscodes93930s
spendsthesgreatestsdollarsson?s16
20.
