Wall Street Prep Excel Crash
Course | Retake Exam Questions
& Answers | 2026 Updated | 100%
Correct
Section 1: Keyboard Shortcuts & Navigation (Q1-25)
Q1. What is the keyboard shortcut to open a file?
• A) Ctrl + N
• B) Ctrl + O
• C) Ctrl + F12
• D) Alt + F
Correct Answer: B) Ctrl + O
Rationale: Ctrl + O is the universal Windows shortcut for the "Open File"
dialog box. Ctrl + N creates a new workbook, and Ctrl + F12 also opens a
file but is less common. The exam emphasizes efficiency, and Ctrl + O is
the standard shortcut taught in the course .
Q2. All of the following are keyboard shortcuts that allow the user to
add more sheets to a workbook EXCEPT:
, • A) Shift + F11
• B) Alt + H + I + S
• C) Alt + H + I + W
• D) Fn + F11 (on some keyboards)
Correct Answer: C) Alt + H + I + W
Rationale: Alt + H + I + S (or Shift + F11) inserts a new worksheet. Alt + H
+ I + W inserts a new window for the current workbook — not a new
sheet. This distinction is critical because adding windows vs. worksheets
serves different purposes in financial modeling .
Q3. What is the keyboard shortcut to open the Format Cells dialog
box?
• A) Ctrl + Shift + F
• B) Ctrl + 1
• C) Alt + Enter
• D) Ctrl + F
Correct Answer: B) Ctrl + 1
Rationale: Ctrl + 1 opens the Format Cells dialog, allowing access to
Number, Alignment, Font, Border, Fill, and Protection tabs. This is one of
the most frequently used shortcuts in financial modeling for consistent
formatting .
Q4. Which shortcut highlights an entire column?
, • A) Shift + Space
• B) Ctrl + Space
• C) Ctrl + A
• D) Alt + Space
Correct Answer: B) Ctrl + Space
Rationale: Ctrl + Space selects the entire column of the active cell. Shift
+ Space selects the entire row. Memorizing this distinction is essential
for efficient column formatting and data manipulation .
Q5. Which shortcut highlights an entire row?
• A) Ctrl + Space
• B) Shift + Space
• C) Ctrl + Shift + Space
• D) Alt + Space
Correct Answer: B) Shift + Space
Rationale: Shift + Space selects the entire row of the active cell. This is
particularly useful when applying formats or inserting/deleting entire
rows in financial models .
Q6. What is the keyboard shortcut for Paste Special?
• A) Ctrl + V
• B) Alt + E + S
, • C) Ctrl + Alt + V
• D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Alt + E + S (legacy shortcut) and Ctrl + Alt + V open the
Paste Special dialog. In modern Excel versions, Ctrl + Alt + V then
pressing V pastes values — a critical shortcut for breaking links and
pasting formula results as static values .
Q7. What is the keyboard shortcut to move sheets within a
workbook?
• A) Ctrl + Page Up/Down
• B) Alt + H + O + M
• C) Ctrl + Shift + Page Up/Down
• D) Alt + E + M
Correct Answer: B) Alt + H + O + M
Rationale: Alt + H + O + M opens the "Move or Copy" dialog box, allowing
precise placement of sheets. While Ctrl + Page Up/Down navigates
between sheets, it does not move them — a key distinction tested on the
exam .
Q8. What are the keyboard shortcuts for auto-fitting a range of
columns?
Course | Retake Exam Questions
& Answers | 2026 Updated | 100%
Correct
Section 1: Keyboard Shortcuts & Navigation (Q1-25)
Q1. What is the keyboard shortcut to open a file?
• A) Ctrl + N
• B) Ctrl + O
• C) Ctrl + F12
• D) Alt + F
Correct Answer: B) Ctrl + O
Rationale: Ctrl + O is the universal Windows shortcut for the "Open File"
dialog box. Ctrl + N creates a new workbook, and Ctrl + F12 also opens a
file but is less common. The exam emphasizes efficiency, and Ctrl + O is
the standard shortcut taught in the course .
Q2. All of the following are keyboard shortcuts that allow the user to
add more sheets to a workbook EXCEPT:
, • A) Shift + F11
• B) Alt + H + I + S
• C) Alt + H + I + W
• D) Fn + F11 (on some keyboards)
Correct Answer: C) Alt + H + I + W
Rationale: Alt + H + I + S (or Shift + F11) inserts a new worksheet. Alt + H
+ I + W inserts a new window for the current workbook — not a new
sheet. This distinction is critical because adding windows vs. worksheets
serves different purposes in financial modeling .
Q3. What is the keyboard shortcut to open the Format Cells dialog
box?
• A) Ctrl + Shift + F
• B) Ctrl + 1
• C) Alt + Enter
• D) Ctrl + F
Correct Answer: B) Ctrl + 1
Rationale: Ctrl + 1 opens the Format Cells dialog, allowing access to
Number, Alignment, Font, Border, Fill, and Protection tabs. This is one of
the most frequently used shortcuts in financial modeling for consistent
formatting .
Q4. Which shortcut highlights an entire column?
, • A) Shift + Space
• B) Ctrl + Space
• C) Ctrl + A
• D) Alt + Space
Correct Answer: B) Ctrl + Space
Rationale: Ctrl + Space selects the entire column of the active cell. Shift
+ Space selects the entire row. Memorizing this distinction is essential
for efficient column formatting and data manipulation .
Q5. Which shortcut highlights an entire row?
• A) Ctrl + Space
• B) Shift + Space
• C) Ctrl + Shift + Space
• D) Alt + Space
Correct Answer: B) Shift + Space
Rationale: Shift + Space selects the entire row of the active cell. This is
particularly useful when applying formats or inserting/deleting entire
rows in financial models .
Q6. What is the keyboard shortcut for Paste Special?
• A) Ctrl + V
• B) Alt + E + S
, • C) Ctrl + Alt + V
• D) Both B and C
Correct Answer: D) Both B and C
Rationale: Both Alt + E + S (legacy shortcut) and Ctrl + Alt + V open the
Paste Special dialog. In modern Excel versions, Ctrl + Alt + V then
pressing V pastes values — a critical shortcut for breaking links and
pasting formula results as static values .
Q7. What is the keyboard shortcut to move sheets within a
workbook?
• A) Ctrl + Page Up/Down
• B) Alt + H + O + M
• C) Ctrl + Shift + Page Up/Down
• D) Alt + E + M
Correct Answer: B) Alt + H + O + M
Rationale: Alt + H + O + M opens the "Move or Copy" dialog box, allowing
precise placement of sheets. While Ctrl + Page Up/Down navigates
between sheets, it does not move them — a key distinction tested on the
exam .
Q8. What are the keyboard shortcuts for auto-fitting a range of
columns?
