100% A+ ANSWER SHEET
WALL STREET PREP EXCEL CRASH COURSE
RETAKE EXAM ANSWER SHEET 48/48
2026 Edition | Updated Curriculum
_______________________________
Comprehensive Answer Key with Detailed Rationales
Financial Modeling & Corporate Finance Training
Industry-Standard Financial Modeling Practices
, TABLE OF CONTENTS
Section 1: Excel Basics and Navigation ................................................................................................3
Section 2: Formulas and Functions......................................................................................................6
Section 3: Data Manipulation and Sorting/Filtering ........................................................................... 10
Section 4: PivotTables and Data Analysis .......................................................................................... 13
Section 5: Charting and Visualization ................................................................................................ 15
Section 6: Financial Functions ........................................................................................................... 17
Section 7: Keyboard Shortcuts and Productivity ................................................................................ 20
Section 8: Troubleshooting and Auditing .......................................................................................... 22
, WSP Excel Crash Course | 2026 Edition | Answer Sheet 48/48
Section 1: Excel Basics and Navigation
Q1: An analyst is creating a financial model where the discount rate in cell B1 needs to remain
fixed when copying a formula down a column. Which cell reference should be used for the
discount rate?
A. B1
B. $B$1 [CORRECT]
C. B$1
D. $B1
Correct Answer: B
Rationale:The correct answer is B ($B$1). This is an absolute reference where both the column (B) and
row (1) are locked with dollar signs. When copying formulas, absolute references never change. Option A
(B1) is a relative reference that would adjust when copied. Option C (B$1) locks only the row, allowing the
column to change. Option D ($B1) locks only the column, allowing the row to change. In financial
modeling, absolute references are essential for fixed inputs like discount rates, tax rates, and other
constants.
Q2: A financial analyst wants to define a range named 'Revenue' that refers to cells C5:C20 for use
in formulas throughout the workbook. What is the most efficient method?
A. Use Formulas > Define Name and manually enter the range
B. Select C5:C20, type 'Revenue' in the Name Box, and press Enter [CORRECT]
C. Create a VBA macro to define the named range
D. Use Ctrl+F3 and add the name through the Name Manager
Correct Answer: B
Rationale:The correct answer is B. The Name Box method is the quickest way to create a named range:
select the cells, click the Name Box (left of the formula bar), type the name, and press Enter. Named
ranges make formulas more readable (e.g., =SUM(Revenue) vs =SUM(C5:C20)) and are easier to maintain.
Option A works but is slower. Option C is unnecessarily complex for this task. Option D opens the Name
Manager which is useful for managing existing names but not the fastest for creating a simple named
range.
Q3: When preparing a large financial model for printing, which feature allows the analyst to keep
the header row visible while scrolling through the worksheet?
A. Split Panes
B. Freeze Panes [CORRECT]
C. Print Area
D. Page Break Preview
Correct Answer: B
WALL STREET PREP EXCEL CRASH COURSE
RETAKE EXAM ANSWER SHEET 48/48
2026 Edition | Updated Curriculum
_______________________________
Comprehensive Answer Key with Detailed Rationales
Financial Modeling & Corporate Finance Training
Industry-Standard Financial Modeling Practices
, TABLE OF CONTENTS
Section 1: Excel Basics and Navigation ................................................................................................3
Section 2: Formulas and Functions......................................................................................................6
Section 3: Data Manipulation and Sorting/Filtering ........................................................................... 10
Section 4: PivotTables and Data Analysis .......................................................................................... 13
Section 5: Charting and Visualization ................................................................................................ 15
Section 6: Financial Functions ........................................................................................................... 17
Section 7: Keyboard Shortcuts and Productivity ................................................................................ 20
Section 8: Troubleshooting and Auditing .......................................................................................... 22
, WSP Excel Crash Course | 2026 Edition | Answer Sheet 48/48
Section 1: Excel Basics and Navigation
Q1: An analyst is creating a financial model where the discount rate in cell B1 needs to remain
fixed when copying a formula down a column. Which cell reference should be used for the
discount rate?
A. B1
B. $B$1 [CORRECT]
C. B$1
D. $B1
Correct Answer: B
Rationale:The correct answer is B ($B$1). This is an absolute reference where both the column (B) and
row (1) are locked with dollar signs. When copying formulas, absolute references never change. Option A
(B1) is a relative reference that would adjust when copied. Option C (B$1) locks only the row, allowing the
column to change. Option D ($B1) locks only the column, allowing the row to change. In financial
modeling, absolute references are essential for fixed inputs like discount rates, tax rates, and other
constants.
Q2: A financial analyst wants to define a range named 'Revenue' that refers to cells C5:C20 for use
in formulas throughout the workbook. What is the most efficient method?
A. Use Formulas > Define Name and manually enter the range
B. Select C5:C20, type 'Revenue' in the Name Box, and press Enter [CORRECT]
C. Create a VBA macro to define the named range
D. Use Ctrl+F3 and add the name through the Name Manager
Correct Answer: B
Rationale:The correct answer is B. The Name Box method is the quickest way to create a named range:
select the cells, click the Name Box (left of the formula bar), type the name, and press Enter. Named
ranges make formulas more readable (e.g., =SUM(Revenue) vs =SUM(C5:C20)) and are easier to maintain.
Option A works but is slower. Option C is unnecessarily complex for this task. Option D opens the Name
Manager which is useful for managing existing names but not the fastest for creating a simple named
range.
Q3: When preparing a large financial model for printing, which feature allows the analyst to keep
the header row visible while scrolling through the worksheet?
A. Split Panes
B. Freeze Panes [CORRECT]
C. Print Area
D. Page Break Preview
Correct Answer: B
