WALL STREET PREP EXCEL CRASH
COURSE ACTUAL EXAM 2026/2027 |
Financial Modeling Skills | Comprehensive
Practice Test | Verified Q&A | Pass
Guaranteed - A+ Graded
SECTION 1: Excel Navigation & Shortcuts (25 Questions)
Q1: You need to add the header "Q1 2027 Financials" in cell A1 and ensure all columns are
identically sized across all 12 monthly worksheets in your workbook. What is the most
efficient approach?
A. Copy cell A1 from the first sheet, then right-click each of the 11 remaining tabs and select
"Paste Special > Formats" individually
B. Group worksheets using Ctrl + Shift + PageUp/PageDown to select all sheets, type the
header in A1, adjust column widths, then press Ctrl + PageUp/PageDown to ungroup and
isolate edits to the active sheet [CORRECT]
C. Right-click any worksheet tab, choose "Select All Sheets," make the changes, then click
any single tab to ungroup
D. Use Format Painter to copy formatting from the first sheet to each subsequent sheet
individually
Rationale: Grouping worksheets via Ctrl + Shift + PageUp/PageDown enables simultaneous
editing across multiple sheets. This is critical for consistent formatting in financial models.
After completing changes, navigating with Ctrl + PageUp/PageDown ensures the group is
broken and subsequent edits apply only to the active sheet—preventing accidental
multi-sheet modifications that could corrupt model integrity. Option C's "Select All Sheets"
lacks the precision of targeted grouping.
Q2: What is the correct keyboard shortcut to open the Paste Special dialog box?
,A. Ctrl + Alt + V
B. Alt + E + S or Alt + H + V + S [CORRECT]
C. Ctrl + Shift + V
D. Alt + P + S
Rationale: Alt + E + S represents the legacy Excel 2003 menu path, while Alt + H + V + S
navigates the modern ribbon (Home tab > Paste > Paste Special). Both remain valid in
Microsoft 365. Paste Special is essential in financial modeling for converting formulas to
values (Alt + E + S + V) or performing mathematical operations during paste operations
without creating circular references.
Q3: You need to group columns B through E to create a collapsible section for "Operating
Expenses" in your financial model. What is the correct shortcut sequence?
A. Select columns B:E, then press Alt + Shift + Right Arrow [CORRECT]
B. Select columns B:E, then press Ctrl + Shift + Right Arrow
C. Select columns B:E, then press Alt + A + G + G
D. Select columns B:E, then press Shift + F12
Rationale: Shift + Alt + Right Arrow (or Alt + Shift + Right Arrow) is the keyboard shortcut to
group selected rows or columns. This creates the collapsible outline controls essential for
tidy financial model presentation. Alt + A + H hides groups (after creation), while Alt + A + J
shows hidden groups. The grouping feature helps users navigate complex models by
expanding/collapsing detail sections.
Q4: After grouping columns as described in Q3, you want to hide the grouped section. What is
the correct shortcut?
A. Alt + A + H [CORRECT]
B. Alt + H + O + H
C. Ctrl + 9
D. Alt + A + G + H
Rationale: Alt + A + H hides the selected grouped columns or rows (Data tab > Outline > Hide
Detail). This differs from simply hiding columns (Ctrl + 0 or Alt + H + O + H) because grouped
,hiding preserves the outline controls for easy expansion. In financial modeling, this creates
professional tiered views: summary level (collapsed) vs. detailed build-up (expanded).
Q5: To show (expand) a previously hidden grouped section, you would use:
A. Alt + A + U
B. Alt + A + J [CORRECT]
C. Alt + H + O + U
D. Ctrl + Shift + 9
Rationale: Alt + A + J shows (expands) the hidden grouped detail (Data tab > Outline > Show
Detail). This is the inverse of Alt + A + H. Mastering these shortcuts allows rapid navigation
between summary and detailed views during model reviews or presentations. The "J"
mnemonic helps recall "Join" or unhide the grouped data.
Q6: You need to freeze the top row and first two columns (A:B) so they remain visible while
scrolling through a large dataset. What is the correct approach?
A. Select cell C2, then press Alt + W + F + F [CORRECT]
B. Select cell B1, then press Alt + W + F + F
C. Press Alt + W + F + R to freeze rows, then Alt + W + F + C to freeze columns separately
D. Select cell A1, then press Alt + W + F + F
Rationale: To freeze both rows above AND columns to the left of a selection, position the
active cell at the intersection (C2 freezes row 1 and columns A:B), then Alt + W + F + F (View
tab > Freeze Panes > Freeze Panes). Excel freezes everything above and left of the active cell.
This is essential for keeping headers and row labels visible in large financial worksheets.
Q7: Which of the following is NOT a valid shortcut for Trace Precedents?
A. Alt + M + P
B. Ctrl + [
C. Ctrl + Alt + [ [CORRECT]
D. Alt + T + U + T (legacy)
, Rationale: Ctrl + Alt + [ is NOT a valid Excel shortcut. The correct shortcuts are Ctrl + [ (jump
to precedents), Alt + M + P (ribbon navigation: Formulas tab > Trace Precedents), or the
legacy Alt + T + U + T. Understanding precedent/dependent tracing is crucial for auditing
financial models and identifying error sources. To remove arrows: Alt + M + A + A.
Q8: You want to split the worksheet window into four panes to view different areas
simultaneously. What is the correct shortcut?
A. Alt + W + S [CORRECT]
B. Alt + W + F + S
C. Alt + W + P + S
D. Ctrl + Alt + S
Rationale: Alt + W + S activates Split Panes (View tab > Split), creating resizable horizontal
and vertical splits. This differs from Freeze Panes as splits create separate scrollable views
of the same worksheet. After splitting, F6 cycles between the four panes. This is useful for
comparing assumptions in the top-left pane with outputs in the bottom-right pane during
model validation.
Q9: After creating a split pane view, how do you navigate between the different panes?
A. Tab key
B. F6 [CORRECT]
C. Ctrl + Tab
D. Alt + Tab
Rationale: F6 cycles the active cursor between split panes in a clockwise direction. Shift + F6
moves counterclockwise. This allows efficient navigation between assumptions (top pane)
and calculations (bottom pane) without scrolling. This is distinct from Ctrl + Tab (switches
between open workbooks) or Alt + Tab (switches between Windows applications).
Q10: You need to insert a comment in cell B5 explaining the revenue growth assumption.
What is the shortcut?
A. Ctrl + Alt + M
B. Shift + F2 [CORRECT]
COURSE ACTUAL EXAM 2026/2027 |
Financial Modeling Skills | Comprehensive
Practice Test | Verified Q&A | Pass
Guaranteed - A+ Graded
SECTION 1: Excel Navigation & Shortcuts (25 Questions)
Q1: You need to add the header "Q1 2027 Financials" in cell A1 and ensure all columns are
identically sized across all 12 monthly worksheets in your workbook. What is the most
efficient approach?
A. Copy cell A1 from the first sheet, then right-click each of the 11 remaining tabs and select
"Paste Special > Formats" individually
B. Group worksheets using Ctrl + Shift + PageUp/PageDown to select all sheets, type the
header in A1, adjust column widths, then press Ctrl + PageUp/PageDown to ungroup and
isolate edits to the active sheet [CORRECT]
C. Right-click any worksheet tab, choose "Select All Sheets," make the changes, then click
any single tab to ungroup
D. Use Format Painter to copy formatting from the first sheet to each subsequent sheet
individually
Rationale: Grouping worksheets via Ctrl + Shift + PageUp/PageDown enables simultaneous
editing across multiple sheets. This is critical for consistent formatting in financial models.
After completing changes, navigating with Ctrl + PageUp/PageDown ensures the group is
broken and subsequent edits apply only to the active sheet—preventing accidental
multi-sheet modifications that could corrupt model integrity. Option C's "Select All Sheets"
lacks the precision of targeted grouping.
Q2: What is the correct keyboard shortcut to open the Paste Special dialog box?
,A. Ctrl + Alt + V
B. Alt + E + S or Alt + H + V + S [CORRECT]
C. Ctrl + Shift + V
D. Alt + P + S
Rationale: Alt + E + S represents the legacy Excel 2003 menu path, while Alt + H + V + S
navigates the modern ribbon (Home tab > Paste > Paste Special). Both remain valid in
Microsoft 365. Paste Special is essential in financial modeling for converting formulas to
values (Alt + E + S + V) or performing mathematical operations during paste operations
without creating circular references.
Q3: You need to group columns B through E to create a collapsible section for "Operating
Expenses" in your financial model. What is the correct shortcut sequence?
A. Select columns B:E, then press Alt + Shift + Right Arrow [CORRECT]
B. Select columns B:E, then press Ctrl + Shift + Right Arrow
C. Select columns B:E, then press Alt + A + G + G
D. Select columns B:E, then press Shift + F12
Rationale: Shift + Alt + Right Arrow (or Alt + Shift + Right Arrow) is the keyboard shortcut to
group selected rows or columns. This creates the collapsible outline controls essential for
tidy financial model presentation. Alt + A + H hides groups (after creation), while Alt + A + J
shows hidden groups. The grouping feature helps users navigate complex models by
expanding/collapsing detail sections.
Q4: After grouping columns as described in Q3, you want to hide the grouped section. What is
the correct shortcut?
A. Alt + A + H [CORRECT]
B. Alt + H + O + H
C. Ctrl + 9
D. Alt + A + G + H
Rationale: Alt + A + H hides the selected grouped columns or rows (Data tab > Outline > Hide
Detail). This differs from simply hiding columns (Ctrl + 0 or Alt + H + O + H) because grouped
,hiding preserves the outline controls for easy expansion. In financial modeling, this creates
professional tiered views: summary level (collapsed) vs. detailed build-up (expanded).
Q5: To show (expand) a previously hidden grouped section, you would use:
A. Alt + A + U
B. Alt + A + J [CORRECT]
C. Alt + H + O + U
D. Ctrl + Shift + 9
Rationale: Alt + A + J shows (expands) the hidden grouped detail (Data tab > Outline > Show
Detail). This is the inverse of Alt + A + H. Mastering these shortcuts allows rapid navigation
between summary and detailed views during model reviews or presentations. The "J"
mnemonic helps recall "Join" or unhide the grouped data.
Q6: You need to freeze the top row and first two columns (A:B) so they remain visible while
scrolling through a large dataset. What is the correct approach?
A. Select cell C2, then press Alt + W + F + F [CORRECT]
B. Select cell B1, then press Alt + W + F + F
C. Press Alt + W + F + R to freeze rows, then Alt + W + F + C to freeze columns separately
D. Select cell A1, then press Alt + W + F + F
Rationale: To freeze both rows above AND columns to the left of a selection, position the
active cell at the intersection (C2 freezes row 1 and columns A:B), then Alt + W + F + F (View
tab > Freeze Panes > Freeze Panes). Excel freezes everything above and left of the active cell.
This is essential for keeping headers and row labels visible in large financial worksheets.
Q7: Which of the following is NOT a valid shortcut for Trace Precedents?
A. Alt + M + P
B. Ctrl + [
C. Ctrl + Alt + [ [CORRECT]
D. Alt + T + U + T (legacy)
, Rationale: Ctrl + Alt + [ is NOT a valid Excel shortcut. The correct shortcuts are Ctrl + [ (jump
to precedents), Alt + M + P (ribbon navigation: Formulas tab > Trace Precedents), or the
legacy Alt + T + U + T. Understanding precedent/dependent tracing is crucial for auditing
financial models and identifying error sources. To remove arrows: Alt + M + A + A.
Q8: You want to split the worksheet window into four panes to view different areas
simultaneously. What is the correct shortcut?
A. Alt + W + S [CORRECT]
B. Alt + W + F + S
C. Alt + W + P + S
D. Ctrl + Alt + S
Rationale: Alt + W + S activates Split Panes (View tab > Split), creating resizable horizontal
and vertical splits. This differs from Freeze Panes as splits create separate scrollable views
of the same worksheet. After splitting, F6 cycles between the four panes. This is useful for
comparing assumptions in the top-left pane with outputs in the bottom-right pane during
model validation.
Q9: After creating a split pane view, how do you navigate between the different panes?
A. Tab key
B. F6 [CORRECT]
C. Ctrl + Tab
D. Alt + Tab
Rationale: F6 cycles the active cursor between split panes in a clockwise direction. Shift + F6
moves counterclockwise. This allows efficient navigation between assumptions (top pane)
and calculations (bottom pane) without scrolling. This is distinct from Ctrl + Tab (switches
between open workbooks) or Alt + Tab (switches between Windows applications).
Q10: You need to insert a comment in cell B5 explaining the revenue growth assumption.
What is the shortcut?
A. Ctrl + Alt + M
B. Shift + F2 [CORRECT]
