Wall Street Prep Excel Crash Course Exam
[Latest] 48 Actual Questions & Detailed Answers
with Rationales
Question 1: Which shortcut combination opens the Format Cells dialog box in Windows Excel 365?
A) Ctrl + F
B) Ctrl + 1
C) Alt + F4
D) Shift + F2
Correct Answer: B) Ctrl + 1
Explanation: Pressing Ctrl + 1 instantly opens the Format Cells dialog for number, alignment, font,
border, fill, or protection settings—an essential time-saver in financial modeling.
Question 2: You inherit a model with hard-coded constants scattered throughout formulas. Which
tool is BEST for auditing precedent cells in one keystroke?
A) Trace Precedents (Ctrl + [ )
B) Show Formulas (Ctrl + ~)
C) Evaluate Formula
,D) Go To Special → Constants
Correct Answer: A) Trace Precedents (Ctrl + [ )
Explanation: Ctrl + [ selects all direct precedent cells on the same sheet, allowing rapid inspection
of inputs; if off-sheet, Trace Precedents arrows appear instead.
Question 3: A junior analyst types “3Q24” into A1. Which single custom format displays it as
“3Q-24” while keeping the cell value numeric for pivot tables?
A) #"-"##
B) 0Q-00
C) @Q-@@
D) #,##0
Correct Answer: B) 0Q-00
Explanation: The custom format 0Q-00 preserves the underlying number 324 (Julian quarter
coding) yet presents the readable label “3Q-24”, satisfying both aesthetics and calc integrity.
Question 4: In a DCF model, you want FCF to grow 3 % annually for 5 years. Which SINGLE Excel
feature ensures inputs remain dynamic instead of hard-coding 1.03?
A) Define Name for 1.03
B) Data Table
C) Scenario Manager
, D) Goal Seek
Correct Answer: A) Define Name for 1.03
Explanation: Creating a named range (e.g., g_FCF=3 %) and referencing it as =(1+g_FCF) means
changing one cell updates the entire forecast—core to best-practice financial modeling.
Question 5: Which combination creates a non-contiguous range selection for simultaneous
formatting?
A) Click-and-drag
B) Ctrl + Click
C) Shift + Space
D) Alt + =
Correct Answer: B) Ctrl + Click
Explanation: Holding Ctrl while clicking individual cells or ranges adds each to the selection, letting
you apply uniform formatting or formulas across disconnected blocks.
Question 6: The formula =$B4*C
3 iscopiedfromD5 toE7.Whatvaluedoestheformulanowreference ?A)
B7 * D
[Latest] 48 Actual Questions & Detailed Answers
with Rationales
Question 1: Which shortcut combination opens the Format Cells dialog box in Windows Excel 365?
A) Ctrl + F
B) Ctrl + 1
C) Alt + F4
D) Shift + F2
Correct Answer: B) Ctrl + 1
Explanation: Pressing Ctrl + 1 instantly opens the Format Cells dialog for number, alignment, font,
border, fill, or protection settings—an essential time-saver in financial modeling.
Question 2: You inherit a model with hard-coded constants scattered throughout formulas. Which
tool is BEST for auditing precedent cells in one keystroke?
A) Trace Precedents (Ctrl + [ )
B) Show Formulas (Ctrl + ~)
C) Evaluate Formula
,D) Go To Special → Constants
Correct Answer: A) Trace Precedents (Ctrl + [ )
Explanation: Ctrl + [ selects all direct precedent cells on the same sheet, allowing rapid inspection
of inputs; if off-sheet, Trace Precedents arrows appear instead.
Question 3: A junior analyst types “3Q24” into A1. Which single custom format displays it as
“3Q-24” while keeping the cell value numeric for pivot tables?
A) #"-"##
B) 0Q-00
C) @Q-@@
D) #,##0
Correct Answer: B) 0Q-00
Explanation: The custom format 0Q-00 preserves the underlying number 324 (Julian quarter
coding) yet presents the readable label “3Q-24”, satisfying both aesthetics and calc integrity.
Question 4: In a DCF model, you want FCF to grow 3 % annually for 5 years. Which SINGLE Excel
feature ensures inputs remain dynamic instead of hard-coding 1.03?
A) Define Name for 1.03
B) Data Table
C) Scenario Manager
, D) Goal Seek
Correct Answer: A) Define Name for 1.03
Explanation: Creating a named range (e.g., g_FCF=3 %) and referencing it as =(1+g_FCF) means
changing one cell updates the entire forecast—core to best-practice financial modeling.
Question 5: Which combination creates a non-contiguous range selection for simultaneous
formatting?
A) Click-and-drag
B) Ctrl + Click
C) Shift + Space
D) Alt + =
Correct Answer: B) Ctrl + Click
Explanation: Holding Ctrl while clicking individual cells or ranges adds each to the selection, letting
you apply uniform formatting or formulas across disconnected blocks.
Question 6: The formula =$B4*C
3 iscopiedfromD5 toE7.Whatvaluedoestheformulanowreference ?A)
B7 * D
