Excel Crash Course Exam from
Maximize your finance and modeling potential by leveraging this comprehensive study guide. Get
exactly what you need to pass this exam
Ace your upcoming finance and investment banking interviews with this verified study package.
Tailored for the this resource gives you everything you need to successfully navigate financial
modeling tests.
Why Choose This Resource?
• 27 Highly-Probable Questions: Includes exact scenarios, data interpretations, and case
questions tested in the real exam.
• Verified, Detailed Answers: Every question includes the precise output along with the
structural rationale so you actually learn the logic.
• Format-Specific: Answers are formatted to match WSP’s strict submission rules (e.g.,
proper rounding and comma separation without currency signs).
• Keyboard Shortcut Mastery: Find solutions to tricky questions on ribbon navigation,
Format Cells dialogs, and worksheet movement.
Key Topics Covered
1. Financial Modeling & Forecasting: Fulfill requirements for forecasting Revenue, Net
Income, and EBITDA margins.
2. Data Lookup & Logic Formulas: Get verified answers for nested IF statements,
HLOOKUP, OFFSET, and CHOOSE functions.
3. Data Analysis Techniques: Learn how to analyze large datasets, interpret cumulative
quantities, and summarize pivot table instructions.
4. Excel Speed & Efficiency: Learn the best keyboard commands to avoid using the mouse
and save time during real-world modeling.
What You Get
1
, Upon purchase, you will receive a downloadable PDF containing all 27 questions and verified
answers. It is the perfect tool for finance students, corporate finance professionals, and anyone
brushing up on advanced Excel concepts before a major assessment.
Quiz_________________?
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: -
ANSWER✅
Alt h i w
Quiz_________________?
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360
day count basis. -
ANSWER✅
=YEARFRAC(D4,D5,2)
Quiz_________________?
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range
lookup' argument if it is necessary. -
ANSWER✅
=HLOOKUP(2016,A1:D4,3)
Quiz_________________?
Identify the formula that outputs 2016 expenses. -
ANSWER✅
2
Maximize your finance and modeling potential by leveraging this comprehensive study guide. Get
exactly what you need to pass this exam
Ace your upcoming finance and investment banking interviews with this verified study package.
Tailored for the this resource gives you everything you need to successfully navigate financial
modeling tests.
Why Choose This Resource?
• 27 Highly-Probable Questions: Includes exact scenarios, data interpretations, and case
questions tested in the real exam.
• Verified, Detailed Answers: Every question includes the precise output along with the
structural rationale so you actually learn the logic.
• Format-Specific: Answers are formatted to match WSP’s strict submission rules (e.g.,
proper rounding and comma separation without currency signs).
• Keyboard Shortcut Mastery: Find solutions to tricky questions on ribbon navigation,
Format Cells dialogs, and worksheet movement.
Key Topics Covered
1. Financial Modeling & Forecasting: Fulfill requirements for forecasting Revenue, Net
Income, and EBITDA margins.
2. Data Lookup & Logic Formulas: Get verified answers for nested IF statements,
HLOOKUP, OFFSET, and CHOOSE functions.
3. Data Analysis Techniques: Learn how to analyze large datasets, interpret cumulative
quantities, and summarize pivot table instructions.
4. Excel Speed & Efficiency: Learn the best keyboard commands to avoid using the mouse
and save time during real-world modeling.
What You Get
1
, Upon purchase, you will receive a downloadable PDF containing all 27 questions and verified
answers. It is the perfect tool for finance students, corporate finance professionals, and anyone
brushing up on advanced Excel concepts before a major assessment.
Quiz_________________?
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: -
ANSWER✅
Alt h i w
Quiz_________________?
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360
day count basis. -
ANSWER✅
=YEARFRAC(D4,D5,2)
Quiz_________________?
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range
lookup' argument if it is necessary. -
ANSWER✅
=HLOOKUP(2016,A1:D4,3)
Quiz_________________?
Identify the formula that outputs 2016 expenses. -
ANSWER✅
2
