WALL STREET PREP EXCEL CRASH COURSE EXAM
2026/2027 | Latest Version Questions and 100% Correct
Answers | Brand New | WSP Excel Certification | Pass
Guaranteed - A+ Graded
Domain 1: Excel Basics and Navigation (6 Questions)
Q1: An analyst is building a financial model where the revenue growth rate in cell B2
needs to be referenced across multiple worksheets while remaining fixed when copied
to other cells. Which cell referencing approach should be used?
A. Relative reference (B2)
B. Absolute reference ($B
2)∗∗[CORRECT]∗∗C.Mixedreference(
B2)
D. Named range without absolute reference
Correct Answer: B
Rationale: Absolute referencing ($B$2) locks both the column and row, ensuring the
reference remains fixed to cell B2 regardless of where the formula is copied. This is
essential for model inputs like growth rates that should remain constant across
calculations. Relative reference (A) would adjust when copied, causing errors. Mixed
reference (C) only locks one dimension (column OR row), which is useful for specific
scenarios like multiplication tables but insufficient here. While named ranges (D)
,improve readability, they don't inherently create absolute references unless combined
with absolute referencing syntax.
Q2: A financial analyst needs to view the header row and first column simultaneously
while scrolling through a large dataset spanning columns A to Z and rows 1 to 5000.
Which Excel feature accomplishes this?
A. Split Panes
B. Freeze Panes [CORRECT]
C. Print Area
D. Grouping
Correct Answer: B
Rationale: Freeze Panes (View → Freeze Panes → Freeze Top Row and First Column)
locks specific rows and columns in place while allowing the rest of the worksheet to
scroll, maintaining visibility of headers and row labels. Split Panes (A) divides the
window into separate scrollable sections but doesn't lock headers in the same way.
Print Area (C) defines what prints, not view navigation. Grouping (D) collapses/expands
data sections but doesn't address the scrolling visibility requirement. For financial
modeling, Freeze Panes is the standard practice for large datasets.
Q3: An analyst creates a named range "Revenue_2026" referring to cells C5:C20. Which
keyboard shortcut opens the Name Manager to edit or delete this named range?
A. Ctrl + F3 [CORRECT]
B. Ctrl + Shift + F3
C. Alt + M + N
D. F3
Correct Answer: A
, Rationale: Ctrl + F3 opens the Name Manager dialog, allowing users to create, edit, or
delete named ranges. This is crucial for model auditing and maintenance. Ctrl + Shift +
F3 (B) creates named ranges from selected labels (Create from Selection). Alt + M + N
(C) doesn't exist as a standard shortcut. F3 (D) pastes a named range into a formula but
doesn't open the Name Manager. Named ranges are Wall Street Prep best practices for
model transparency and error reduction.
Q4: An analyst needs to ensure that only dates between January 1, 2026, and December
31, 2026, can be entered in cells A1:A100. Which feature should be applied?
A. Conditional Formatting
B. Data Validation [CORRECT]
C. Text to Columns
D. Protect Sheet
Correct Answer: B
Rationale: Data Validation (Data → Data Validation → Allow: Date, Between: 1/1/2026
and 12/31/2026) restricts input to specific criteria before entry, preventing errors at the
source. Conditional Formatting (A) highlights invalid data after entry but doesn't prevent
it. Text to Columns (C) splits data across columns, unrelated to input restriction. Protect
Sheet (D) prevents editing but doesn't validate data types or ranges. For financial
models, Data Validation is essential for input sheets to maintain data integrity.
Q5: Which keyboard shortcut selects the entire current data region (contiguous block of
cells containing data)?
A. Ctrl + Shift + 8
B. Ctrl + A [CORRECT]
C. Ctrl + Shift + End
D. Alt + A + C
2026/2027 | Latest Version Questions and 100% Correct
Answers | Brand New | WSP Excel Certification | Pass
Guaranteed - A+ Graded
Domain 1: Excel Basics and Navigation (6 Questions)
Q1: An analyst is building a financial model where the revenue growth rate in cell B2
needs to be referenced across multiple worksheets while remaining fixed when copied
to other cells. Which cell referencing approach should be used?
A. Relative reference (B2)
B. Absolute reference ($B
2)∗∗[CORRECT]∗∗C.Mixedreference(
B2)
D. Named range without absolute reference
Correct Answer: B
Rationale: Absolute referencing ($B$2) locks both the column and row, ensuring the
reference remains fixed to cell B2 regardless of where the formula is copied. This is
essential for model inputs like growth rates that should remain constant across
calculations. Relative reference (A) would adjust when copied, causing errors. Mixed
reference (C) only locks one dimension (column OR row), which is useful for specific
scenarios like multiplication tables but insufficient here. While named ranges (D)
,improve readability, they don't inherently create absolute references unless combined
with absolute referencing syntax.
Q2: A financial analyst needs to view the header row and first column simultaneously
while scrolling through a large dataset spanning columns A to Z and rows 1 to 5000.
Which Excel feature accomplishes this?
A. Split Panes
B. Freeze Panes [CORRECT]
C. Print Area
D. Grouping
Correct Answer: B
Rationale: Freeze Panes (View → Freeze Panes → Freeze Top Row and First Column)
locks specific rows and columns in place while allowing the rest of the worksheet to
scroll, maintaining visibility of headers and row labels. Split Panes (A) divides the
window into separate scrollable sections but doesn't lock headers in the same way.
Print Area (C) defines what prints, not view navigation. Grouping (D) collapses/expands
data sections but doesn't address the scrolling visibility requirement. For financial
modeling, Freeze Panes is the standard practice for large datasets.
Q3: An analyst creates a named range "Revenue_2026" referring to cells C5:C20. Which
keyboard shortcut opens the Name Manager to edit or delete this named range?
A. Ctrl + F3 [CORRECT]
B. Ctrl + Shift + F3
C. Alt + M + N
D. F3
Correct Answer: A
, Rationale: Ctrl + F3 opens the Name Manager dialog, allowing users to create, edit, or
delete named ranges. This is crucial for model auditing and maintenance. Ctrl + Shift +
F3 (B) creates named ranges from selected labels (Create from Selection). Alt + M + N
(C) doesn't exist as a standard shortcut. F3 (D) pastes a named range into a formula but
doesn't open the Name Manager. Named ranges are Wall Street Prep best practices for
model transparency and error reduction.
Q4: An analyst needs to ensure that only dates between January 1, 2026, and December
31, 2026, can be entered in cells A1:A100. Which feature should be applied?
A. Conditional Formatting
B. Data Validation [CORRECT]
C. Text to Columns
D. Protect Sheet
Correct Answer: B
Rationale: Data Validation (Data → Data Validation → Allow: Date, Between: 1/1/2026
and 12/31/2026) restricts input to specific criteria before entry, preventing errors at the
source. Conditional Formatting (A) highlights invalid data after entry but doesn't prevent
it. Text to Columns (C) splits data across columns, unrelated to input restriction. Protect
Sheet (D) prevents editing but doesn't validate data types or ranges. For financial
models, Data Validation is essential for input sheets to maintain data integrity.
Q5: Which keyboard shortcut selects the entire current data region (contiguous block of
cells containing data)?
A. Ctrl + Shift + 8
B. Ctrl + A [CORRECT]
C. Ctrl + Shift + End
D. Alt + A + C
