Wall Street Prep Excel Crash Course Actual Exam 2026/2027
– Complete Practice Test with Detailed Rationales | 100%
Verified | Pass Guaranteed – A+ Graded
SECTION 1: Keyboard Shortcuts & Productivity (Q1-Q30)
Q1: A financial analyst needs to open an existing Excel workbook without using the
mouse. The correct keyboard shortcut is:
A. Ctrl+N
B. Ctrl+O [CORRECT]
C. Ctrl+S
D. Ctrl+P
Correct Answer: B
Rationale: Ctrl+O opens the Open dialog box to access existing workbooks. Ctrl+N
creates a new blank workbook, Ctrl+S saves the current workbook, and Ctrl+P opens the
Print dialog. Mastering file operation shortcuts eliminates mouse dependency and
accelerates workflow in financial modeling. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q2: An analyst working on a complex financial model with multiple data tables wants to
prevent Excel from automatically recalculating every time a cell changes. The
recommended workbook calculation setting is:
A. Automatic
B. Automatic Except for Data Tables [CORRECT]
C. Manual
D. Manual with Recalculate Before Save disabled
Correct Answer: B
,Rationale: Automatic Except for Data Tables is the recommended setting for financial
modeling because it prevents data tables from recalculating with every cell change
(which can severely slow large models) while keeping all other formulas current. Manual
requires pressing F9 to recalculate, which risks stale data. Automatic causes
performance issues with data tables. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q3: An analyst needs to navigate from Sheet1 to Sheet2 within the same workbook
using only the keyboard. The correct shortcut is:
A. Ctrl+Tab
B. Ctrl+PageDown [CORRECT]
C. Alt+PageDown
D. Shift+F11
Correct Answer: B
Rationale: Ctrl+PageDown moves to the next worksheet to the right; Ctrl+PageUp moves
to the previous worksheet. Ctrl+Tab cycles through open Excel windows, not
worksheets. Alt+PageDown moves one screen to the right within a worksheet.
Shift+F11 inserts a new worksheet. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q4: An analyst needs to insert a new worksheet in a workbook without using the mouse.
The correct keyboard shortcut is:
A. Ctrl+N
B. Alt+H+I+W [CORRECT]
C. Ctrl+Shift+N
D. Alt+W+I
Correct Answer: B
Rationale: Alt+H+I+W activates the ribbon (Alt), selects the Home tab (H), opens the
Insert dropdown (I), and selects Insert Worksheet (W). Shift+F11 is an alternative
,shortcut that inserts a new worksheet directly. Ctrl+N creates a new workbook, not a
worksheet. [100% VERIFIED – WSP Excel Crash Course 2026/2027]
Q5: An analyst has copied a range of cells containing formulas and wants to paste only
the values (not the formulas) into another location. The correct Paste Special shortcut
sequence is:
A. Ctrl+V, then press V again
B. Alt+E+S+V [CORRECT]
C. Alt+H+V+F
D. Ctrl+Shift+V
Correct Answer: B
Rationale: Alt+E+S+V opens the Paste Special dialog (Alt+E+S) and selects Values (V).
The ribbon shortcut Alt+H+V+V also pastes values. Pasting values breaks formula links
and prevents unintended changes when source data updates—critical when sharing
outputs or creating static reports from dynamic models. [100% VERIFIED – WSP Excel
Crash Course 2026/2027]
Q6: An analyst needs to select an entire column of data using only the keyboard. The
correct shortcut is:
A. Shift+Spacebar
B. Ctrl+Spacebar [CORRECT]
C. Ctrl+A
D. Alt+Spacebar
Correct Answer: B
Rationale: Ctrl+Spacebar selects the entire column containing the active cell.
Shift+Spacebar selects the entire row. Ctrl+A selects the current data region (or entire
worksheet if pressed twice). These selection shortcuts are essential for efficient
formatting, copying, and manipulation of large datasets in financial models. [100%
VERIFIED – WSP Excel Crash Course 2026/2027]
, Q7: An analyst needs to select an entire row using only the keyboard. The correct
shortcut is:
A. Ctrl+Spacebar
B. Shift+Spacebar [CORRECT]
C. Ctrl+R
D. Alt+R
Correct Answer: B
Rationale: Shift+Spacebar selects the entire row containing the active cell.
Ctrl+Spacebar selects the entire column. Ctrl+R fills right (copies cell contents to the
right), and Alt+R has no standard Excel function. Row selection is frequently used when
inserting or deleting rows in financial statement models. [100% VERIFIED – WSP Excel
Crash Course 2026/2027]
Q8: An analyst needs to open the Format Cells dialog to change number formatting. The
correct keyboard shortcut is:
A. Ctrl+F
B. Ctrl+H
C. Ctrl+1 [CORRECT]
D. Ctrl+Shift+F
Correct Answer: C
Rationale: Ctrl+1 opens the Format Cells dialog box, providing access to Number,
Alignment, Font, Border, Fill, and Protection tabs. This is faster than navigating through
the Home tab ribbon. Ctrl+F opens Find, Ctrl+H opens Find and Replace, and
Ctrl+Shift+F opens the Format Cells dialog with the Font tab pre-selected. [100%
VERIFIED – WSP Excel Crash Course 2026/2027]
Q9: An analyst is working with a large dataset and needs to freeze the top row so it
remains visible while scrolling. The correct keyboard shortcut sequence is:
A. Alt+W+F+F [CORRECT]
B. Alt+W+F+R
C. Ctrl+W+F
– Complete Practice Test with Detailed Rationales | 100%
Verified | Pass Guaranteed – A+ Graded
SECTION 1: Keyboard Shortcuts & Productivity (Q1-Q30)
Q1: A financial analyst needs to open an existing Excel workbook without using the
mouse. The correct keyboard shortcut is:
A. Ctrl+N
B. Ctrl+O [CORRECT]
C. Ctrl+S
D. Ctrl+P
Correct Answer: B
Rationale: Ctrl+O opens the Open dialog box to access existing workbooks. Ctrl+N
creates a new blank workbook, Ctrl+S saves the current workbook, and Ctrl+P opens the
Print dialog. Mastering file operation shortcuts eliminates mouse dependency and
accelerates workflow in financial modeling. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q2: An analyst working on a complex financial model with multiple data tables wants to
prevent Excel from automatically recalculating every time a cell changes. The
recommended workbook calculation setting is:
A. Automatic
B. Automatic Except for Data Tables [CORRECT]
C. Manual
D. Manual with Recalculate Before Save disabled
Correct Answer: B
,Rationale: Automatic Except for Data Tables is the recommended setting for financial
modeling because it prevents data tables from recalculating with every cell change
(which can severely slow large models) while keeping all other formulas current. Manual
requires pressing F9 to recalculate, which risks stale data. Automatic causes
performance issues with data tables. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q3: An analyst needs to navigate from Sheet1 to Sheet2 within the same workbook
using only the keyboard. The correct shortcut is:
A. Ctrl+Tab
B. Ctrl+PageDown [CORRECT]
C. Alt+PageDown
D. Shift+F11
Correct Answer: B
Rationale: Ctrl+PageDown moves to the next worksheet to the right; Ctrl+PageUp moves
to the previous worksheet. Ctrl+Tab cycles through open Excel windows, not
worksheets. Alt+PageDown moves one screen to the right within a worksheet.
Shift+F11 inserts a new worksheet. [100% VERIFIED – WSP Excel Crash Course
2026/2027]
Q4: An analyst needs to insert a new worksheet in a workbook without using the mouse.
The correct keyboard shortcut is:
A. Ctrl+N
B. Alt+H+I+W [CORRECT]
C. Ctrl+Shift+N
D. Alt+W+I
Correct Answer: B
Rationale: Alt+H+I+W activates the ribbon (Alt), selects the Home tab (H), opens the
Insert dropdown (I), and selects Insert Worksheet (W). Shift+F11 is an alternative
,shortcut that inserts a new worksheet directly. Ctrl+N creates a new workbook, not a
worksheet. [100% VERIFIED – WSP Excel Crash Course 2026/2027]
Q5: An analyst has copied a range of cells containing formulas and wants to paste only
the values (not the formulas) into another location. The correct Paste Special shortcut
sequence is:
A. Ctrl+V, then press V again
B. Alt+E+S+V [CORRECT]
C. Alt+H+V+F
D. Ctrl+Shift+V
Correct Answer: B
Rationale: Alt+E+S+V opens the Paste Special dialog (Alt+E+S) and selects Values (V).
The ribbon shortcut Alt+H+V+V also pastes values. Pasting values breaks formula links
and prevents unintended changes when source data updates—critical when sharing
outputs or creating static reports from dynamic models. [100% VERIFIED – WSP Excel
Crash Course 2026/2027]
Q6: An analyst needs to select an entire column of data using only the keyboard. The
correct shortcut is:
A. Shift+Spacebar
B. Ctrl+Spacebar [CORRECT]
C. Ctrl+A
D. Alt+Spacebar
Correct Answer: B
Rationale: Ctrl+Spacebar selects the entire column containing the active cell.
Shift+Spacebar selects the entire row. Ctrl+A selects the current data region (or entire
worksheet if pressed twice). These selection shortcuts are essential for efficient
formatting, copying, and manipulation of large datasets in financial models. [100%
VERIFIED – WSP Excel Crash Course 2026/2027]
, Q7: An analyst needs to select an entire row using only the keyboard. The correct
shortcut is:
A. Ctrl+Spacebar
B. Shift+Spacebar [CORRECT]
C. Ctrl+R
D. Alt+R
Correct Answer: B
Rationale: Shift+Spacebar selects the entire row containing the active cell.
Ctrl+Spacebar selects the entire column. Ctrl+R fills right (copies cell contents to the
right), and Alt+R has no standard Excel function. Row selection is frequently used when
inserting or deleting rows in financial statement models. [100% VERIFIED – WSP Excel
Crash Course 2026/2027]
Q8: An analyst needs to open the Format Cells dialog to change number formatting. The
correct keyboard shortcut is:
A. Ctrl+F
B. Ctrl+H
C. Ctrl+1 [CORRECT]
D. Ctrl+Shift+F
Correct Answer: C
Rationale: Ctrl+1 opens the Format Cells dialog box, providing access to Number,
Alignment, Font, Border, Fill, and Protection tabs. This is faster than navigating through
the Home tab ribbon. Ctrl+F opens Find, Ctrl+H opens Find and Replace, and
Ctrl+Shift+F opens the Format Cells dialog with the Font tab pre-selected. [100%
VERIFIED – WSP Excel Crash Course 2026/2027]
Q9: An analyst is working with a large dataset and needs to freeze the top row so it
remains visible while scrolling. The correct keyboard shortcut sequence is:
A. Alt+W+F+F [CORRECT]
B. Alt+W+F+R
C. Ctrl+W+F
