1
WSP Excel Crash Course Exam 2026/2027 Actual
Exam | Latest Version Questions & 100% Correct
Answers with Detailed Rationales | Wall Street
Prep | Pass Guaranteed - A+ Graded
Section 1: Excel Fundamentals
Q1: The keyboard shortcut to save a workbook in Excel is:
A. Ctrl + S [CORRECT]
B. Ctrl + P
C. Ctrl + O
D. Ctrl + N
Correct Answer: A
Rationale: Ctrl + S is the universal shortcut for Save. Ctrl + P is Print. Ctrl + O is Open. Ctrl + N
is New.
Q2: In financial modeling, which color is standard convention for "Hardcoded" input cells
(assumptions)?
A. Black font
B. Blue font [CORRECT]
C. Green font
D. Red font
Correct Answer: B
Rationale: Standard financial modeling color coding uses Blue font for hardcoded
inputs/assumptions, Black font for formulas, and Green font for links to other worksheets.
,2
Q3: Which function key toggles between relative, absolute, and mixed cell references while
editing a formula?
A. F2
B. F4 [CORRECT]
C. F5
D. F9
Correct Answer: B
Rationale: F4 cycles through reference types (e.g., A1 -> $A$1 -> $A1 -> A$1). F2 edits the
active cell. F5 opens the "Go To" dialog. F9 calculates all worksheets.
Q4: To quickly select an entire data region (current region) surrounding the active cell, the
keyboard shortcut is:
A. Ctrl + A [CORRECT]
B. Ctrl + Shift + End
C. Ctrl + Spacebar
D. Shift + Spacebar
Correct Answer: A
Rationale: Ctrl + A selects the current region. Pressing Ctrl + A again selects the entire
worksheet. Ctrl + Spacebar selects the entire column, and Shift + Spacebar selects the entire row.
Q5: A user wants to enter the same data into multiple cells simultaneously. After selecting the
cells, they should type the data and press:
A. Enter
B. Ctrl + Enter [CORRECT]
C. Shift + Enter
D. Alt + Enter
,3
Correct Answer: B
Rationale: Ctrl + Enter fills the selected cell range with the same entry. Enter just moves
selection to the next cell.
Q6: The keyboard shortcut to insert a new worksheet is:
A. F11
B. Shift + F11 [CORRECT]
C. Alt + F11
D. Ctrl + F11
Correct Answer: B
Rationale: Shift + F11 inserts a new worksheet. F11 creates a default chart of the selected data.
Alt + F11 opens the VBA editor.
Q7: Which of the following is NOT a valid error code in Excel?
A. #N/A
B. #VALUE!
C. #NAME?
D. #INPUT [CORRECT]
Correct Answer: D
Rationale: There is no #INPUT error. Common errors include #N/A (value not found), #VALUE!
(wrong data type), #NAME? (unrecognized text/formula), #REF! (invalid reference), #DIV/0!
(division by zero).
Q8: To open the "Paste Special" dialog box using the keyboard, the shortcut sequence is:
A. Ctrl + V, then Ctrl + S
B. Ctrl + Alt + V [CORRECT]
, 4
C. Alt + E, then S
D. Ctrl + Shift + V
Correct Answer: B
Rationale: Ctrl + Alt + V opens the Paste Special dialog. (Legacy shortcut Alt + E, S also works
on many systems).
Q9: You want to view two worksheets from the same workbook side-by-side. Which feature
should you use?
A. Freeze Panes
B. New Window [CORRECT]
C. Split
D. Arrange All
Correct Answer: B
Rationale: You must open a "New Window" of the same workbook to view different sheets
simultaneously. "View Side by Side" (Synchronous Scrolling) compares two different workbooks
usually, but requires New Window for same workbook views.
Q10: Which keyboard shortcut allows you to edit the contents of a cell directly?
A. F4
B. F2 [CORRECT]
C. F5
D. F7
Correct Answer: B
Rationale: F2 places the cursor inside the cell formula bar or the cell itself (depending on
settings) to allow editing.
WSP Excel Crash Course Exam 2026/2027 Actual
Exam | Latest Version Questions & 100% Correct
Answers with Detailed Rationales | Wall Street
Prep | Pass Guaranteed - A+ Graded
Section 1: Excel Fundamentals
Q1: The keyboard shortcut to save a workbook in Excel is:
A. Ctrl + S [CORRECT]
B. Ctrl + P
C. Ctrl + O
D. Ctrl + N
Correct Answer: A
Rationale: Ctrl + S is the universal shortcut for Save. Ctrl + P is Print. Ctrl + O is Open. Ctrl + N
is New.
Q2: In financial modeling, which color is standard convention for "Hardcoded" input cells
(assumptions)?
A. Black font
B. Blue font [CORRECT]
C. Green font
D. Red font
Correct Answer: B
Rationale: Standard financial modeling color coding uses Blue font for hardcoded
inputs/assumptions, Black font for formulas, and Green font for links to other worksheets.
,2
Q3: Which function key toggles between relative, absolute, and mixed cell references while
editing a formula?
A. F2
B. F4 [CORRECT]
C. F5
D. F9
Correct Answer: B
Rationale: F4 cycles through reference types (e.g., A1 -> $A$1 -> $A1 -> A$1). F2 edits the
active cell. F5 opens the "Go To" dialog. F9 calculates all worksheets.
Q4: To quickly select an entire data region (current region) surrounding the active cell, the
keyboard shortcut is:
A. Ctrl + A [CORRECT]
B. Ctrl + Shift + End
C. Ctrl + Spacebar
D. Shift + Spacebar
Correct Answer: A
Rationale: Ctrl + A selects the current region. Pressing Ctrl + A again selects the entire
worksheet. Ctrl + Spacebar selects the entire column, and Shift + Spacebar selects the entire row.
Q5: A user wants to enter the same data into multiple cells simultaneously. After selecting the
cells, they should type the data and press:
A. Enter
B. Ctrl + Enter [CORRECT]
C. Shift + Enter
D. Alt + Enter
,3
Correct Answer: B
Rationale: Ctrl + Enter fills the selected cell range with the same entry. Enter just moves
selection to the next cell.
Q6: The keyboard shortcut to insert a new worksheet is:
A. F11
B. Shift + F11 [CORRECT]
C. Alt + F11
D. Ctrl + F11
Correct Answer: B
Rationale: Shift + F11 inserts a new worksheet. F11 creates a default chart of the selected data.
Alt + F11 opens the VBA editor.
Q7: Which of the following is NOT a valid error code in Excel?
A. #N/A
B. #VALUE!
C. #NAME?
D. #INPUT [CORRECT]
Correct Answer: D
Rationale: There is no #INPUT error. Common errors include #N/A (value not found), #VALUE!
(wrong data type), #NAME? (unrecognized text/formula), #REF! (invalid reference), #DIV/0!
(division by zero).
Q8: To open the "Paste Special" dialog box using the keyboard, the shortcut sequence is:
A. Ctrl + V, then Ctrl + S
B. Ctrl + Alt + V [CORRECT]
, 4
C. Alt + E, then S
D. Ctrl + Shift + V
Correct Answer: B
Rationale: Ctrl + Alt + V opens the Paste Special dialog. (Legacy shortcut Alt + E, S also works
on many systems).
Q9: You want to view two worksheets from the same workbook side-by-side. Which feature
should you use?
A. Freeze Panes
B. New Window [CORRECT]
C. Split
D. Arrange All
Correct Answer: B
Rationale: You must open a "New Window" of the same workbook to view different sheets
simultaneously. "View Side by Side" (Synchronous Scrolling) compares two different workbooks
usually, but requires New Window for same workbook views.
Q10: Which keyboard shortcut allows you to edit the contents of a cell directly?
A. F4
B. F2 [CORRECT]
C. F5
D. F7
Correct Answer: B
Rationale: F2 places the cursor inside the cell formula bar or the cell itself (depending on
settings) to allow editing.
