WSP Excel Crash Course Final Exam 2024
Latest Version | Wall Street Prep Style
60 Questions with 100% Correct Answers & In-Depth Rationales
Time Limit: 90 minutes
Passing Score: 85%
Instructions: This exam simulates real-world investment banking and corporate finance
Excel scenarios. Answer all questions. For formula questions, syntax must be exact.
Section 1: Conceptual Knowledge & Shortcuts (Q1-20)
Q1: You are finalizing a pitchbook and need to apply the "Accounting Number Format"
(with $ and two decimals) to an entire income statement range. What is the fastest
method?
A. Right-click → Format Cells → Number Tab → Accounting → Set decimal places to 2
B. **Use the keyboard shortcut Ctrl+Shift+
.[CORRECT]∗∗C.ClickHome→Number→CurrencyD.UseAlt+H+KtoapplytheC
ommaStyle,thenmanuallyadd
symbols
Correct Answer: B
,Rationale: B is correct. Ctrl+Shift+$ is the dedicated keyboard shortcut for
Accounting format, which aligns currency symbols and decimals for financial
statements. While A achieves the same result, it requires 5+ clicks. C applies Currency
format (symbol adjacent to numbers, not aligned). D applies Comma Style (no currency
symbol) and manual editing is error-prone and non-standard.
Q2: In a financial model, you need to toggle between displaying formulas and their
results to audit calculations. Which shortcut accomplishes this instantly?
A. Ctrl+` (grave accent/backtick). [CORRECT]
B. Ctrl+F2
C. Alt+M+V
D. F9
Correct Answer: A
Rationale: A is correct. `Ctrl+`` (grave accent, located above Tab) toggles "Show
Formulas" mode, displaying all formulas in their cells instead of results. This is essential
for model auditing. B opens Print Preview. C opens the Formula Auditing dialog. D
recalculates all formulas but doesn't display them.
Q3: You are building a DCF model and need to fill a formula down 500 rows while
maintaining absolute references for the discount rate cell ($B$1). Which method is
most efficient?
A. Copy the cell with Ctrl+C, select the range, then paste
,B. Drag the fill handle while holding Ctrl+D after establishing absolute references.
[CORRECT]
C. Type the formula manually in each cell to ensure accuracy
D. Use Ctrl+R to fill right, then transpose
Correct Answer: B
Rationale: B is correct. After establishing absolute references ($B$1) in the first cell,
double-clicking the fill handle (or using Ctrl+D for selected range) copies the formula
down while preserving absolute references. A works but requires more steps. C is
inefficient and error-prone. D fills horizontally, not vertically.
Q4: Which keyboard shortcut opens the "Format Cells" dialog box immediately?
A. Ctrl+1. [CORRECT]
B. Ctrl+Shift+F
C. Alt+H+O+I
D. F4
Correct Answer: A
Rationale: A is correct. Ctrl+1 opens the Format Cells dialog instantly, allowing access
to Number, Alignment, Font, Border, Fill, and Protection tabs. B opens the Font dialog in
some versions. C auto-fits column width. D toggles absolute/relative references or
repeats last action.
, Q5: You need to select all cells that directly precedents (feed into) the active cell for
formula auditing. Which shortcut is correct?
A. Ctrl+[ (open bracket). [CORRECT]
B. Ctrl+] (close bracket)
C. Ctrl+Shift+{
D. Alt+M+P
Correct Answer: A
Rationale: A is correct. Ctrl+[ selects all direct precedent cells (those referenced by
the formula in the active cell). B selects dependent cells (those that reference the active
cell). C selects all direct and indirect precedents. D opens the Formula Auditing menu
but doesn't execute the selection.
Q6: In financial modeling best practice, which of the following represents a "hardcode"
that should be avoided in calculation cells?
A. =Revenue*Gross_Margin
B. =SUM(A1:A10)
C. =1000000*1.05 [CORRECT]
D. =VLOOKUP(A1,Table,2,FALSE)
Correct Answer: C
Rationale: C is correct. Hardcoding values like 1,000,000 and 1.05 directly into formulas
violates modeling best practices. These should be inputs in separate, clearly labeled
Latest Version | Wall Street Prep Style
60 Questions with 100% Correct Answers & In-Depth Rationales
Time Limit: 90 minutes
Passing Score: 85%
Instructions: This exam simulates real-world investment banking and corporate finance
Excel scenarios. Answer all questions. For formula questions, syntax must be exact.
Section 1: Conceptual Knowledge & Shortcuts (Q1-20)
Q1: You are finalizing a pitchbook and need to apply the "Accounting Number Format"
(with $ and two decimals) to an entire income statement range. What is the fastest
method?
A. Right-click → Format Cells → Number Tab → Accounting → Set decimal places to 2
B. **Use the keyboard shortcut Ctrl+Shift+
.[CORRECT]∗∗C.ClickHome→Number→CurrencyD.UseAlt+H+KtoapplytheC
ommaStyle,thenmanuallyadd
symbols
Correct Answer: B
,Rationale: B is correct. Ctrl+Shift+$ is the dedicated keyboard shortcut for
Accounting format, which aligns currency symbols and decimals for financial
statements. While A achieves the same result, it requires 5+ clicks. C applies Currency
format (symbol adjacent to numbers, not aligned). D applies Comma Style (no currency
symbol) and manual editing is error-prone and non-standard.
Q2: In a financial model, you need to toggle between displaying formulas and their
results to audit calculations. Which shortcut accomplishes this instantly?
A. Ctrl+` (grave accent/backtick). [CORRECT]
B. Ctrl+F2
C. Alt+M+V
D. F9
Correct Answer: A
Rationale: A is correct. `Ctrl+`` (grave accent, located above Tab) toggles "Show
Formulas" mode, displaying all formulas in their cells instead of results. This is essential
for model auditing. B opens Print Preview. C opens the Formula Auditing dialog. D
recalculates all formulas but doesn't display them.
Q3: You are building a DCF model and need to fill a formula down 500 rows while
maintaining absolute references for the discount rate cell ($B$1). Which method is
most efficient?
A. Copy the cell with Ctrl+C, select the range, then paste
,B. Drag the fill handle while holding Ctrl+D after establishing absolute references.
[CORRECT]
C. Type the formula manually in each cell to ensure accuracy
D. Use Ctrl+R to fill right, then transpose
Correct Answer: B
Rationale: B is correct. After establishing absolute references ($B$1) in the first cell,
double-clicking the fill handle (or using Ctrl+D for selected range) copies the formula
down while preserving absolute references. A works but requires more steps. C is
inefficient and error-prone. D fills horizontally, not vertically.
Q4: Which keyboard shortcut opens the "Format Cells" dialog box immediately?
A. Ctrl+1. [CORRECT]
B. Ctrl+Shift+F
C. Alt+H+O+I
D. F4
Correct Answer: A
Rationale: A is correct. Ctrl+1 opens the Format Cells dialog instantly, allowing access
to Number, Alignment, Font, Border, Fill, and Protection tabs. B opens the Font dialog in
some versions. C auto-fits column width. D toggles absolute/relative references or
repeats last action.
, Q5: You need to select all cells that directly precedents (feed into) the active cell for
formula auditing. Which shortcut is correct?
A. Ctrl+[ (open bracket). [CORRECT]
B. Ctrl+] (close bracket)
C. Ctrl+Shift+{
D. Alt+M+P
Correct Answer: A
Rationale: A is correct. Ctrl+[ selects all direct precedent cells (those referenced by
the formula in the active cell). B selects dependent cells (those that reference the active
cell). C selects all direct and indirect precedents. D opens the Formula Auditing menu
but doesn't execute the selection.
Q6: In financial modeling best practice, which of the following represents a "hardcode"
that should be avoided in calculation cells?
A. =Revenue*Gross_Margin
B. =SUM(A1:A10)
C. =1000000*1.05 [CORRECT]
D. =VLOOKUP(A1,Table,2,FALSE)
Correct Answer: C
Rationale: C is correct. Hardcoding values like 1,000,000 and 1.05 directly into formulas
violates modeling best practices. These should be inputs in separate, clearly labeled
