WALL STREET PREP EXCEL CRASH COURSE RETAKE EXAM ANSWER SHEET 2026 | 100% A+ 105/105 Complete Solutions | Financial Modelling Excel Proficiency | Pass Guaranteed!!Verified Questions and Answers.

WALL STREET PREP EXCEL CRASH COURSE RETAKE
EXAM ANSWER SHEET 2026 | 100% A+ 105/105
Complete Solutions | Financial Modelling Excel
Proficiency | Pass Guaranteed!!Verified Questions
and Answers.

WALL STREET PREP EXCEL CRASH COURSE – RETAKE EXAM

SECTION 1: KEYBOARD SHORTCUTS (Windows & Mac) – 20 Questions

1. What is the Windows shortcut to insert a new worksheet?

• A) Ctrl + N

• B) Shift + F11

• C) Alt + =

• D) Ctrl + Page Up

✅ Answer: B
Rationale: Shift + F11 inserts a new worksheet. Ctrl+N opens a new workbook.

2. On a Mac, what is the shortcut for "Go To Special"?

• A) Cmd + G

• B) Ctrl + G

• C) F5

• D) Cmd + Shift + G

✅ Answer: A (Cmd+G opens Go To; then click Special) – but full shortcut: Cmd+G then
Alt+S on Mac Excel.
Best answer: A, as Cmd+G is the gateway.

3. Which shortcut edits the active cell (like F2 on Windows)?

• A) Ctrl + U

• B) Cmd + U (Mac)

• C) Enter

, • D) Spacebar

✅ Answer: B (Cmd+U on Mac, F2 on Windows).

4. To toggle absolute/relative references, you press:

• A) F4

• B) Ctrl + R

• C) Alt + F4

• D) Shift + F4

✅ Answer: A – F4 cycles $A$1 → A$1 → $A1 → A1.

5. Which shortcut pastes values only?

• A) Ctrl + V

• B) Alt + E, S, V, Enter

• C) Ctrl + Alt + V, then V

• D) Both B & C

✅ Answer: D – legacy Alt+E,S,V or Ctrl+Alt+V then V.

6. Shortcut to select entire data region (contiguous):

• A) Ctrl + A once

• B) Ctrl + Shift + Space

• C) Ctrl + *

• D) All of the above

✅ Answer: D – they all select current region depending on context.

7. To insert a new row above current row:

• A) Ctrl + Shift + =

• B) Alt + I, R

• C) Ctrl + +

• D) All of the above

✅ Answer: D – multiple shortcuts exist.

8. On Mac Excel, what is the shortcut for "Fill Down"?

• A) Cmd + D

, • B) Ctrl + D

• C) Cmd + R

• D) Shift + Down

✅ Answer: A – Cmd + D.

9. Which shortcut opens the Format Cells dialog box?

• A) Ctrl + 1

• B) Ctrl + F

• C) Alt + O, E

• D) Cmd + 1 (Mac)

✅ Answer: A (Windows); for Mac it's Cmd+1. Question defaults to Windows unless
specified. So A.

10. To trace precedents of a formula:

• A) Alt + M, P

• B) Ctrl + [

• C) Alt + T, U, T

• D) Both A & B

✅ Answer: D – Ctrl+[ is quick trace, Alt+M,P is ribbon.

11. Shortcut to group rows/columns:

• A) Alt + Shift + →

• B) Alt + A, G, G

• C) Shift + Alt + Right arrow

• D) All of the above

✅ Answer: D – all valid.

12. Which key repeats the last action?

• A) F4

• B) Ctrl + Y

• C) Cmd + Y (Mac)

• D) All of the above