WALL STREET PREP EXCEL CRASH COURSE EXAM
2026/2027 | Newest Version | Complete Verified Answers |
Pass Guaranteed - A+ Graded
[Section 1: Keyboard Shortcuts & Navigation Mastery (Q1-12)]
Q1. An investment banking analyst needs to select the entire current data region
(contiguous block) without using the mouse. Which keyboard shortcut accomplishes
this?
A. Ctrl+A
B. Ctrl+Shift+End
C. Ctrl+Shift+*
D. Ctrl+Shift+Arrow
C. Ctrl+Shift+* [CORRECT]
Rationale: Ctrl+Shift+* selects the current data region bounded by empty rows and
columns, which is the precise shortcut for selecting a contiguous block in financial
modeling. Ctrl+A selects all cells or the current region depending on context, while
Ctrl+Shift+End selects to the last used cell and Ctrl+Shift+Arrow selects in one direction
only.
Correct Answer: C
Q2. An analyst is building a model and needs to edit an active cell directly in the cell (not
the formula bar) to audit a formula. Which key toggles this mode?
A. F1
B. F2
C. F4
D. F5
B. F2 [CORRECT]
Rationale: F2 toggles edit mode for the active cell, allowing the analyst to see
color-coded precedents directly in the cell. F1 opens Help, F4 toggles absolute/mixed
references while editing, and F5 opens the Go To dialog.
Correct Answer: B
,Q3. While editing a formula, an analyst needs to cycle through reference types (A1 →
$A$1 → A1→ A1). Which key accomplishes this?
A. F2
B. F3
C. F4
D. F5
C. F4 [CORRECT]
Rationale: F4 toggles through absolute, mixed, and relative reference types during
formula editing. F2 enters edit mode, F3 opens the Paste Name dialog, and F5 opens Go
To.
Correct Answer: C
Q4. An analyst needs to fill down a formula from the top cell to the bottom of an
adjacent data column containing 500 rows. Which is the most efficient keyboard-only
method?
A. Ctrl+D after selecting the range including the existing formula cell
B. Ctrl+R after selecting the range
C. Ctrl+Shift+End followed by Ctrl+D
D. Ctrl+Enter after selecting the range
A. Ctrl+D after selecting the range including the existing formula cell [CORRECT]
Rationale: Ctrl+D fills down a formula through a selected range. The analyst selects the
top cell with the formula, extends the selection down (e.g., Ctrl+Shift+Down), then
presses Ctrl+D. Ctrl+R fills right, not down. Ctrl+Enter enters the same formula into all
selected cells simultaneously, which is not the same as fill down from a top cell.
Correct Answer: A
Q5. To paste values only (stripping formulas and formatting) using ribbon keyboard
shortcuts, which sequence is correct?
A. Alt, H, V, V
B. Alt, E, S, V
C. Ctrl, V, then Ctrl, T
D. Alt, N, V
A. Alt, H, V, V [CORRECT]
, Rationale: The modern ribbon shortcut for Paste Values is Alt, H (Home), V (Paste), V
(Values). Alt, E, S, V is the legacy Excel 2003 menu shortcut. Ctrl+V pastes everything,
and Alt, N, V opens the Paste Special dialog but is not the direct sequence.
Correct Answer: A
Q6. An analyst needs to apply or remove AutoFilter dropdown arrows on a data table.
Which shortcut toggles filters?
A. Ctrl+Shift+F
B. Alt, D, F, F
C. Ctrl+Shift+L
D. Alt, A, T
C. Ctrl+Shift+L [CORRECT]
Rationale: Ctrl+Shift+L toggles AutoFilter on and off. Alt, D, F, F is the legacy shortcut.
Alt, A, T is the ribbon shortcut for Total Row in tables, not filters. Ctrl+Shift+F opens the
Format Cells dialog in some contexts.
Correct Answer: C
Q7. An analyst on a Mac needs to insert a table. The Windows shortcut is Ctrl+T. Which
is the correct Mac equivalent?
A. Command+T
B. Control+T
C. Option+T
D. Command+Shift+T
A. Command+T [CORRECT]
Rationale: On Mac Excel, Command+T inserts a table, mirroring the Windows Ctrl+T
shortcut. Control+T is not the standard Mac modifier for this function, and
Command+Shift+T is typically used to reopen closed tabs in browsers, not Excel tables.
Correct Answer: A
Q8. To select an entire column of data without the mouse, which shortcut should the
analyst use?
A. Ctrl+Space
B. Shift+Space
C. Ctrl+Shift+Space
D. Alt+Space
2026/2027 | Newest Version | Complete Verified Answers |
Pass Guaranteed - A+ Graded
[Section 1: Keyboard Shortcuts & Navigation Mastery (Q1-12)]
Q1. An investment banking analyst needs to select the entire current data region
(contiguous block) without using the mouse. Which keyboard shortcut accomplishes
this?
A. Ctrl+A
B. Ctrl+Shift+End
C. Ctrl+Shift+*
D. Ctrl+Shift+Arrow
C. Ctrl+Shift+* [CORRECT]
Rationale: Ctrl+Shift+* selects the current data region bounded by empty rows and
columns, which is the precise shortcut for selecting a contiguous block in financial
modeling. Ctrl+A selects all cells or the current region depending on context, while
Ctrl+Shift+End selects to the last used cell and Ctrl+Shift+Arrow selects in one direction
only.
Correct Answer: C
Q2. An analyst is building a model and needs to edit an active cell directly in the cell (not
the formula bar) to audit a formula. Which key toggles this mode?
A. F1
B. F2
C. F4
D. F5
B. F2 [CORRECT]
Rationale: F2 toggles edit mode for the active cell, allowing the analyst to see
color-coded precedents directly in the cell. F1 opens Help, F4 toggles absolute/mixed
references while editing, and F5 opens the Go To dialog.
Correct Answer: B
,Q3. While editing a formula, an analyst needs to cycle through reference types (A1 →
$A$1 → A1→ A1). Which key accomplishes this?
A. F2
B. F3
C. F4
D. F5
C. F4 [CORRECT]
Rationale: F4 toggles through absolute, mixed, and relative reference types during
formula editing. F2 enters edit mode, F3 opens the Paste Name dialog, and F5 opens Go
To.
Correct Answer: C
Q4. An analyst needs to fill down a formula from the top cell to the bottom of an
adjacent data column containing 500 rows. Which is the most efficient keyboard-only
method?
A. Ctrl+D after selecting the range including the existing formula cell
B. Ctrl+R after selecting the range
C. Ctrl+Shift+End followed by Ctrl+D
D. Ctrl+Enter after selecting the range
A. Ctrl+D after selecting the range including the existing formula cell [CORRECT]
Rationale: Ctrl+D fills down a formula through a selected range. The analyst selects the
top cell with the formula, extends the selection down (e.g., Ctrl+Shift+Down), then
presses Ctrl+D. Ctrl+R fills right, not down. Ctrl+Enter enters the same formula into all
selected cells simultaneously, which is not the same as fill down from a top cell.
Correct Answer: A
Q5. To paste values only (stripping formulas and formatting) using ribbon keyboard
shortcuts, which sequence is correct?
A. Alt, H, V, V
B. Alt, E, S, V
C. Ctrl, V, then Ctrl, T
D. Alt, N, V
A. Alt, H, V, V [CORRECT]
, Rationale: The modern ribbon shortcut for Paste Values is Alt, H (Home), V (Paste), V
(Values). Alt, E, S, V is the legacy Excel 2003 menu shortcut. Ctrl+V pastes everything,
and Alt, N, V opens the Paste Special dialog but is not the direct sequence.
Correct Answer: A
Q6. An analyst needs to apply or remove AutoFilter dropdown arrows on a data table.
Which shortcut toggles filters?
A. Ctrl+Shift+F
B. Alt, D, F, F
C. Ctrl+Shift+L
D. Alt, A, T
C. Ctrl+Shift+L [CORRECT]
Rationale: Ctrl+Shift+L toggles AutoFilter on and off. Alt, D, F, F is the legacy shortcut.
Alt, A, T is the ribbon shortcut for Total Row in tables, not filters. Ctrl+Shift+F opens the
Format Cells dialog in some contexts.
Correct Answer: C
Q7. An analyst on a Mac needs to insert a table. The Windows shortcut is Ctrl+T. Which
is the correct Mac equivalent?
A. Command+T
B. Control+T
C. Option+T
D. Command+Shift+T
A. Command+T [CORRECT]
Rationale: On Mac Excel, Command+T inserts a table, mirroring the Windows Ctrl+T
shortcut. Control+T is not the standard Mac modifier for this function, and
Command+Shift+T is typically used to reopen closed tabs in browsers, not Excel tables.
Correct Answer: A
Q8. To select an entire column of data without the mouse, which shortcut should the
analyst use?
A. Ctrl+Space
B. Shift+Space
C. Ctrl+Shift+Space
D. Alt+Space
