WSP Excel Crash Course Exam: (Latest 2026/2027
) Questions & Answers with Detailed Rationales |
Grade A
PREPARED FOR:
Wall Street Prep Excel Crash Course Examination
DOCUMENT INCLUDES:
● Exam-style questions
● Correct answers
● Detailed rationales
● Key topics covered
TOPICS COVERED:
● Excel Shortcuts & Navigation
● Cell Referencing & Formula Construction
● Lookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
● Logical Functions (IF, AND, OR, IFS)
● Financial Functions (NPV, IRR, PV, FV, PMT)
● PivotTables & Data Visualization
● Conditional Formatting & Data Validation
● What-If Analysis (Goal Seek, Data Tables, Scenario Manager)
● Array Formulas & Dynamic Arrays
● Financial Modeling Best Practices
SECTION 1: Excel Shortcuts & Navigation
Question 1
,In a large financial model, which keyboard shortcut jumps directly to the last cell
containing data in the current worksheet?
A. Ctrl+Home
B. Ctrl+End
C. Ctrl+Arrow Down
D. Ctrl+Shift+End
Correct Answer: B
Rationale: Ctrl+End moves the active cell to the last used cell in the worksheet (the
intersection of the last column and last row with data). Ctrl+Home (Option A) moves to
cell A1. Ctrl+Arrow Down (Option C) jumps to the edge of the current data region in the
direction of the arrow. Ctrl+Shift+End (Option D) selects the range from the active cell to
the last used cell, rather than simply moving the cursor.
Question 2
While editing a formula in Excel, pressing the F4 key will:
A. Open the Find and Replace dialog
B. Toggle the cell reference between absolute, relative, and mixed references
C. Repeat the last action performed
D. Insert a new worksheet into the workbook
Correct Answer: B
Rationale: When the cursor is positioned within or immediately after a cell reference in a
formula, pressing F4 cycles through the reference types: $A$1 (absolute),
A1(mixed—rowabsolute), A1 (mixed—column absolute), and A1 (relative). Option A
describes Ctrl+H. Option C describes the effect of F4 when not in edit mode. Option D is
performed by Shift+F11.
Question 3
, Which keyboard shortcut selects the entire current data region surrounding the active
cell?
A. Ctrl+A
B. Ctrl+Shift+8
C. Both A and B are correct
D. Alt+Shift+Right Arrow
Correct Answer: C
Rationale: Both Ctrl+A and Ctrl+Shift+8 (the asterisk key on the numeric keypad) select
the current contiguous data region surrounding the active cell. Alt+Shift+Right Arrow
(Option D) is the shortcut to group rows or columns, not to select a data region.
Question 4
To quickly fill a formula down through a selected range of cells, the correct keyboard
shortcut is:
A. Ctrl+R
B. Ctrl+D
C. Ctrl+E
D. Alt+E+I+D
Correct Answer: B
Rationale: Ctrl+D fills down the contents of the top cell of a selection through all
selected cells below it. Ctrl+R (Option A) fills right. Ctrl+E (Option C) activates Flash Fill.
Alt+E+I+D (Option D) is an older menu path for the fill down command but is not the
direct keyboard shortcut.
Question 5
Pressing the Alt key in Excel activates:
) Questions & Answers with Detailed Rationales |
Grade A
PREPARED FOR:
Wall Street Prep Excel Crash Course Examination
DOCUMENT INCLUDES:
● Exam-style questions
● Correct answers
● Detailed rationales
● Key topics covered
TOPICS COVERED:
● Excel Shortcuts & Navigation
● Cell Referencing & Formula Construction
● Lookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
● Logical Functions (IF, AND, OR, IFS)
● Financial Functions (NPV, IRR, PV, FV, PMT)
● PivotTables & Data Visualization
● Conditional Formatting & Data Validation
● What-If Analysis (Goal Seek, Data Tables, Scenario Manager)
● Array Formulas & Dynamic Arrays
● Financial Modeling Best Practices
SECTION 1: Excel Shortcuts & Navigation
Question 1
,In a large financial model, which keyboard shortcut jumps directly to the last cell
containing data in the current worksheet?
A. Ctrl+Home
B. Ctrl+End
C. Ctrl+Arrow Down
D. Ctrl+Shift+End
Correct Answer: B
Rationale: Ctrl+End moves the active cell to the last used cell in the worksheet (the
intersection of the last column and last row with data). Ctrl+Home (Option A) moves to
cell A1. Ctrl+Arrow Down (Option C) jumps to the edge of the current data region in the
direction of the arrow. Ctrl+Shift+End (Option D) selects the range from the active cell to
the last used cell, rather than simply moving the cursor.
Question 2
While editing a formula in Excel, pressing the F4 key will:
A. Open the Find and Replace dialog
B. Toggle the cell reference between absolute, relative, and mixed references
C. Repeat the last action performed
D. Insert a new worksheet into the workbook
Correct Answer: B
Rationale: When the cursor is positioned within or immediately after a cell reference in a
formula, pressing F4 cycles through the reference types: $A$1 (absolute),
A1(mixed—rowabsolute), A1 (mixed—column absolute), and A1 (relative). Option A
describes Ctrl+H. Option C describes the effect of F4 when not in edit mode. Option D is
performed by Shift+F11.
Question 3
, Which keyboard shortcut selects the entire current data region surrounding the active
cell?
A. Ctrl+A
B. Ctrl+Shift+8
C. Both A and B are correct
D. Alt+Shift+Right Arrow
Correct Answer: C
Rationale: Both Ctrl+A and Ctrl+Shift+8 (the asterisk key on the numeric keypad) select
the current contiguous data region surrounding the active cell. Alt+Shift+Right Arrow
(Option D) is the shortcut to group rows or columns, not to select a data region.
Question 4
To quickly fill a formula down through a selected range of cells, the correct keyboard
shortcut is:
A. Ctrl+R
B. Ctrl+D
C. Ctrl+E
D. Alt+E+I+D
Correct Answer: B
Rationale: Ctrl+D fills down the contents of the top cell of a selection through all
selected cells below it. Ctrl+R (Option A) fills right. Ctrl+E (Option C) activates Flash Fill.
Alt+E+I+D (Option D) is an older menu path for the fill down command but is not the
direct keyboard shortcut.
Question 5
Pressing the Alt key in Excel activates:
