Wall Street Prep Excel Crash Course Practice
Exam (2026 Latest Version)
Excel Interface and Navigation
Q1: You are building a three-statement financial model with 15+ worksheets. You need to
quickly navigate from the Summary tab to the Debt Schedule tab without scrolling through
every sheet. Which navigation method is most efficient?
A. Click each worksheet tab until you find Debt Schedule
B. Use Ctrl + Page Down repeatedly until you reach the desired sheet
C. Right-click the sheet navigation arrows in the bottom-left corner, then select "Debt Schedule"
from the list [CORRECT]
D. Use the scroll bar at the bottom of the Excel window
Correct Answer: C
Rationale: Right-clicking the sheet navigation arrows in the bottom-left corner of Excel opens a
list of all worksheets in the workbook, allowing you to jump directly to any sheet. This is the
fastest method for navigating workbooks with many tabs, which is standard practice in financial
modeling where models commonly contain 10-20+ worksheets.
Q2: While building a financial model, you notice that when you scroll down past row 50, your
column headers (Revenue, COGS, Gross Profit, etc.) disappear. You need to keep these headers
visible while scrolling through thousands of rows of projections. What should you do?
A. Copy the header row and paste it every 50 rows
B. Select the row below the headers, go to View → Freeze Panes → Freeze Panes [CORRECT]
C. Use Split Screen feature from the View tab
D. Hide all rows above your current position
Correct Answer: B
Rationale: Freeze Panes locks specific rows or columns in place while you scroll through other
parts of the worksheet. To freeze row 1 (headers), select row 2 and go to View → Freeze Panes
→ Freeze Panes. This keeps row 1 visible regardless of how far down you scroll. This is essential
for navigating large financial models with hundreds or thousands of rows.
,Q3: You need to select an entire column of data containing 500,000 rows of historical stock
prices without dragging your mouse. What is the most efficient selection method?
A. Click the first cell, hold Shift, and press Page Down repeatedly
B. Click the column letter at the top of the worksheet [CORRECT]
C. Click the first cell and press Ctrl + Shift + End
D. Use the Name Box to type the entire range manually
Correct Answer: B
Rationale: Clicking the column letter (e.g., "A," "B," "C") at the top of the worksheet selects the
entire column—all 1,048,576 rows—instantly. This is the fastest and most accurate method for
selecting entire columns, which is commonly needed when applying formatting, sorting, or
copying large datasets in financial analysis.
Q4: You are working on a valuation model and need to reference the "Historical Data" sheet
from the "DCF Analysis" sheet. In the cell, you type ='Historical Data'!B5. What does this
formula accomplish?
A. It creates a circular reference between the two sheets
B. It references cell B5 from the Historical Data sheet in the current cell [CORRECT]
C. It moves cell B5 from Historical Data to the DCF Analysis sheet
D. It creates a hyperlink to the Historical Data sheet
Correct Answer: B
Rationale: The syntax ='Sheet Name'!CellReference creates a cross-sheet reference. In this case,
the formula pulls the value from cell B5 on the Historical Data sheet into the current cell on the
DCF Analysis sheet. Cross-sheet references are fundamental to financial modeling, as models
typically separate assumptions, historical data, and calculations across multiple worksheets.
Q5: You need to locate a specific cell containing "EBITDA Margin" in a 50-tab financial model.
Which tool allows you to search across all worksheets simultaneously?
A. The Name Box search feature
B. Go To Special dialog box
C. Find and Replace dialog box with "Within: Workbook" selected under Options [CORRECT]
D. The Data tab → Data Validation
Correct Answer: C
, Rationale: The Find and Replace dialog box (Ctrl + F) has an "Options" button that allows you to
change the search scope from "Sheet" to "Workbook." This enables searching across all
worksheets simultaneously. This feature is invaluable for locating specific formulas,
assumptions, or labels in complex financial models with multiple tabs.
Q6: You are reviewing a colleague's model and need to see which cells contain formulas versus
hardcoded values. What is the most efficient approach?
A. Click each cell individually and check the formula bar
B. Press Ctrl + ` (backtick) to toggle formula view for the entire worksheet [CORRECT]
C. Use the Go To Special dialog box and select "Formulas"
D. Apply a filter to show only formula cells
Correct Answer: B
Rationale: Ctrl + ` (backtick, located below the Escape key) toggles between displaying formula
results and displaying the actual formulas in all cells. This provides a quick visual overview of
which cells contain formulas versus constants. For financial modeling review, this shortcut is
essential for auditing model integrity and identifying hardcoded values that should be formula-
driven.
Q7: When working with a large dataset that extends beyond the visible screen area, which
keyboard shortcut jumps to the last used cell in the worksheet?
A. Ctrl + End [CORRECT]
B. Ctrl + Home
C. Ctrl + Down Arrow
D. Ctrl + Shift + End
Correct Answer: A
Rationale: Ctrl + End jumps to the last used cell in the worksheet (the bottom-right most cell
that contains data or formatting). This is useful for quickly determining the extent of your data
range. Ctrl + Home returns to cell A1, while Ctrl + Down Arrow moves to the last cell in the
current data region, not necessarily the last used cell in the entire worksheet.
Q8: You need to view two different sections of the same worksheet simultaneously to compare
Q1 and Q4 data in a large annual financial model. What feature should you use?
Exam (2026 Latest Version)
Excel Interface and Navigation
Q1: You are building a three-statement financial model with 15+ worksheets. You need to
quickly navigate from the Summary tab to the Debt Schedule tab without scrolling through
every sheet. Which navigation method is most efficient?
A. Click each worksheet tab until you find Debt Schedule
B. Use Ctrl + Page Down repeatedly until you reach the desired sheet
C. Right-click the sheet navigation arrows in the bottom-left corner, then select "Debt Schedule"
from the list [CORRECT]
D. Use the scroll bar at the bottom of the Excel window
Correct Answer: C
Rationale: Right-clicking the sheet navigation arrows in the bottom-left corner of Excel opens a
list of all worksheets in the workbook, allowing you to jump directly to any sheet. This is the
fastest method for navigating workbooks with many tabs, which is standard practice in financial
modeling where models commonly contain 10-20+ worksheets.
Q2: While building a financial model, you notice that when you scroll down past row 50, your
column headers (Revenue, COGS, Gross Profit, etc.) disappear. You need to keep these headers
visible while scrolling through thousands of rows of projections. What should you do?
A. Copy the header row and paste it every 50 rows
B. Select the row below the headers, go to View → Freeze Panes → Freeze Panes [CORRECT]
C. Use Split Screen feature from the View tab
D. Hide all rows above your current position
Correct Answer: B
Rationale: Freeze Panes locks specific rows or columns in place while you scroll through other
parts of the worksheet. To freeze row 1 (headers), select row 2 and go to View → Freeze Panes
→ Freeze Panes. This keeps row 1 visible regardless of how far down you scroll. This is essential
for navigating large financial models with hundreds or thousands of rows.
,Q3: You need to select an entire column of data containing 500,000 rows of historical stock
prices without dragging your mouse. What is the most efficient selection method?
A. Click the first cell, hold Shift, and press Page Down repeatedly
B. Click the column letter at the top of the worksheet [CORRECT]
C. Click the first cell and press Ctrl + Shift + End
D. Use the Name Box to type the entire range manually
Correct Answer: B
Rationale: Clicking the column letter (e.g., "A," "B," "C") at the top of the worksheet selects the
entire column—all 1,048,576 rows—instantly. This is the fastest and most accurate method for
selecting entire columns, which is commonly needed when applying formatting, sorting, or
copying large datasets in financial analysis.
Q4: You are working on a valuation model and need to reference the "Historical Data" sheet
from the "DCF Analysis" sheet. In the cell, you type ='Historical Data'!B5. What does this
formula accomplish?
A. It creates a circular reference between the two sheets
B. It references cell B5 from the Historical Data sheet in the current cell [CORRECT]
C. It moves cell B5 from Historical Data to the DCF Analysis sheet
D. It creates a hyperlink to the Historical Data sheet
Correct Answer: B
Rationale: The syntax ='Sheet Name'!CellReference creates a cross-sheet reference. In this case,
the formula pulls the value from cell B5 on the Historical Data sheet into the current cell on the
DCF Analysis sheet. Cross-sheet references are fundamental to financial modeling, as models
typically separate assumptions, historical data, and calculations across multiple worksheets.
Q5: You need to locate a specific cell containing "EBITDA Margin" in a 50-tab financial model.
Which tool allows you to search across all worksheets simultaneously?
A. The Name Box search feature
B. Go To Special dialog box
C. Find and Replace dialog box with "Within: Workbook" selected under Options [CORRECT]
D. The Data tab → Data Validation
Correct Answer: C
, Rationale: The Find and Replace dialog box (Ctrl + F) has an "Options" button that allows you to
change the search scope from "Sheet" to "Workbook." This enables searching across all
worksheets simultaneously. This feature is invaluable for locating specific formulas,
assumptions, or labels in complex financial models with multiple tabs.
Q6: You are reviewing a colleague's model and need to see which cells contain formulas versus
hardcoded values. What is the most efficient approach?
A. Click each cell individually and check the formula bar
B. Press Ctrl + ` (backtick) to toggle formula view for the entire worksheet [CORRECT]
C. Use the Go To Special dialog box and select "Formulas"
D. Apply a filter to show only formula cells
Correct Answer: B
Rationale: Ctrl + ` (backtick, located below the Escape key) toggles between displaying formula
results and displaying the actual formulas in all cells. This provides a quick visual overview of
which cells contain formulas versus constants. For financial modeling review, this shortcut is
essential for auditing model integrity and identifying hardcoded values that should be formula-
driven.
Q7: When working with a large dataset that extends beyond the visible screen area, which
keyboard shortcut jumps to the last used cell in the worksheet?
A. Ctrl + End [CORRECT]
B. Ctrl + Home
C. Ctrl + Down Arrow
D. Ctrl + Shift + End
Correct Answer: A
Rationale: Ctrl + End jumps to the last used cell in the worksheet (the bottom-right most cell
that contains data or formatting). This is useful for quickly determining the extent of your data
range. Ctrl + Home returns to cell A1, while Ctrl + Down Arrow moves to the last cell in the
current data region, not necessarily the last used cell in the entire worksheet.
Q8: You need to view two different sections of the same worksheet simultaneously to compare
Q1 and Q4 data in a large annual financial model. What feature should you use?
