2024 Wall Street Excel Crash Course Exam Course Exam With Answers (50 Solved Questions)

Preview (5 of 14 Pages)

100%

Purchase to unlock

Loading page image...

ExcelCrashCourseExamfromWallStreetPrep-WallStreetPrepQuestionsAndAnswers Updated 2024Instructions: Questions 1-4 use the financial modelontabQ1-4intheExam Workbook. Complete the model by filling in the blank cellsbeforeanswering the question below. Answers should be rounded tothe nearest whole number, comma separating 000s, NOT written incurrency format. So if the answer is $5,505,210.50, you would input5,505,210.1.WhatisforecastRevenuein2017?13,642,0212.WhatisforecastNetIncomein2016?925,7773.If Depreciation&Amortization as a % of Capital Expenditures ischanged to 30%, what is Net Income in 2017? 1,123,4384.WhatistheEBITDA%Marginin2018?17.1%Instructions:Questions5-19 use the data table ontabQ5-19 intheExam Workbook. We strongly recommend you analyze thisdata with the aid of a pivot table. You may also benefit fromadding some extra calculation columns to the dataset.Answersfornumerical datashould be roundedto thenearest1decimal, comma separating 000s, NOT written in currencyformat. So if the answer is $10,500.658, you would input10,500.7.5.Overtheentireanalysisperiod,whichsalesrepsoldthehighestcumulative quantity of a single item?RobStewart6.In the last question you determined the sales person who sold the

Loading page image...

highestcumulativequantityofasingleitem.Whatistheitemcodeofthat item?167.Overtheentireanalysisperiod,whatisthesecondhighestsellingitem code by quantity?398.Overtheentireanalysisperiod,whatisthehighestsellingitemcodeby quantity?16

Loading page image...

9.Only considering postal codes 93372, 93403 and 93434, whichpostalcodehadthehighesttotalprofitduringthemonthofMarch?9337210.Inthelastquestionyoudeterminedthepostalcodethathadthehighest total profit during the month of March. What was the profit?13691.411.DuringthemonthofApril,whichpostalcodeboughtthemostofitem13 by quantity?9355812.In the last question, you determined the postal code that bought themost of item 13 by quantity for the month of April. What was thatquantity?2413.WhatisthetotalofAmyAdam’ssalesovertheanalysisperiod?492,153.814.Inthepreviousquestion,youdeterminedthethetotalofAmy’ssalesover the analysis period. What was her total profit?255,548.115.During the three-month period of January through March, what wasthe quantity of item 23 sold while Fred Rubble was the Manager onduty?78416.DuringthemonthofMay,howmanypostalcodesboughtmorethan700 products by quantity?417.Over the entire analysis period, which sales rep gave the mostdiscountsbydollaramount?Enterthenameas:FirstnameLastname.Oliver Winslow18.In the previous question, you determined which sales rep gave themost discounts by dollar amount. What was that amount?17444.419.Overtheentireanalysisperiod,whichitemcodedidpostalcode93930 spend the greatest dollars on?16

Loading page image...

20.IdentifyafunctionforcellD6thatwillreturnthefractionoftheyear elapsed assuming a 360 day count basis.•=STUB(D4,D5)•=YEARFRAC(D4,D5,2)•=DAYS360(D4,D5)•=YEARFRAC(D4,D5)B21.Identifytheformulathatwillalwaysoutputadatethatistheend-of-month date 3 months after the date inputted in D5.•=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5))•=EOMONTH(3,D5)

Preview Mode

This document has 14 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

SAP S/4HANA Sales Certification Guide: Application Associate Exam (2021)

SAP S/4HANA Business Process Integration Certification Guide: Application Associate Exam (2021)

SAP HANA 2.0 Certification Guide: Technology Associate Exam (2021)

SAP S/4HANA Production Planning and Manufacturing Certification Guide: Application Associate Exam (2022)

2024 Ornamental And Turf Pesticide Applicator Practice Exam With Answers (78 Solved Questions)

State of Colorado Question and Verified Answers with Answers (40 Solved Questions)

LETRS Unit 4 Assessment with Answers (15 Solved Questions)

COG170 Cogito Epic Training Fundamentals Practice Exam with Answers (220 Solved Questions)

2023 AVID Media Composer 101 Certification Practice Exam with Answers (233 Solved Questions)

Prophecy General ICU RN A v2 with Answers (55 Solved Questions)

Company

Explore

Study Tools