WSP | EXCEL
OBJECTIVE ASSESSMENT - EXAM
Excel Crash Course
Exam
Wall Street Prep | 2026/2027
75 100% 2026/2027
QUESTIONS VERIFIED ANSWERS EDITION
TOPICS COVERED
Excel Fundamentals & Navigation Financial Modeling Basics
Formulas & Functions Charting & Visualization
Data Analysis & PivotTables
COVER PAGE - 1
, SECTION 1 | Excel Fundamentals & Navigation | Q1-Q19 | EXCEL CRASH COURSE 2026/2027
Q1 Question 1 of 75
Q1. An analyst needs to copy the formatting from one cell and apply it to a new range without
altering the existing data. What keyboard shortcut sequence performs a Paste Special Formats
operation?
A. Alt, E, S, T
B. Alt, E, S, V
C. Alt, E, S, F
D. Alt, H, V, V
Correct Answer: A
Rationale:
The legacy shortcut Alt, E, S opens the Paste Special dialog, and T selects Formats. Alt, E, S, V
pastes Values, and Alt, E, S, F pastes Formulas.
Q2 Question 2 of 75
Q2. A modeler wants to select an entire column of data quickly using the keyboard. What is the
correct shortcut to highlight the active column?
A. Shift + Spacebar
B. Ctrl + Spacebar
C. Ctrl + Shift + Down Arrow
D. Alt + Spacebar
Correct Answer: B
Rationale:
Ctrl + Spacebar selects the entire column of the active cell. Shift + Spacebar selects the entire row.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 2 of 40
, Q3 Question 3 of 75
Q3. An associate is reviewing a financial model and wants to see which cells feed into the active
formula. What keyboard shortcut visually traces the precedents of the active cell?
A. Ctrl + [
B. Alt, M, D
C. Alt, M, P
D. F5
Correct Answer: C
Rationale:
Alt, M, P triggers the Trace Precedents command, drawing blue arrows to the source cells. Alt, M, D
traces dependents.
Q4 Question 4 of 75
Q4. A user wants to enter edit mode for the currently selected cell to modify a formula without
using the mouse. What key should the user press?
A. F12
B. F4
C. F9
D. F2
Correct Answer: D
Rationale:
Pressing F2 enters edit mode for the active cell, placing the cursor at the end of the formula. F4
toggles absolute and relative references.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 3 of 40
, Q5 Question 5 of 75
Q5. When formatting a large dataset, an analyst wants to open the Format Cells dialog box
instantly. What keyboard shortcut should be used?
A. Ctrl + 1
B. Ctrl + Shift + F
C. Alt + H + F
D. Ctrl + 5
Correct Answer: A
Rationale:
Ctrl + 1 is the standard shortcut to open the Format Cells dialog box in Excel. The other options do
not directly open this comprehensive menu.
Q6 Question 6 of 75
Q6. An analyst has hidden several rows in a worksheet but wants to switch to a more
professional method that allows other users to expand and collapse the rows easily. What
feature should the analyst use?
A. Custom Views
B. Group (Shift + Alt + Right Arrow)
C. AutoFilter
D. Data Validation
Correct Answer: B
Rationale:
Grouping rows (Shift + Alt + Right Arrow) creates a collapsible +/- toggle on the left margin, which is
the Wall Street Prep best convention over hiding rows.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 4 of 40
OBJECTIVE ASSESSMENT - EXAM
Excel Crash Course
Exam
Wall Street Prep | 2026/2027
75 100% 2026/2027
QUESTIONS VERIFIED ANSWERS EDITION
TOPICS COVERED
Excel Fundamentals & Navigation Financial Modeling Basics
Formulas & Functions Charting & Visualization
Data Analysis & PivotTables
COVER PAGE - 1
, SECTION 1 | Excel Fundamentals & Navigation | Q1-Q19 | EXCEL CRASH COURSE 2026/2027
Q1 Question 1 of 75
Q1. An analyst needs to copy the formatting from one cell and apply it to a new range without
altering the existing data. What keyboard shortcut sequence performs a Paste Special Formats
operation?
A. Alt, E, S, T
B. Alt, E, S, V
C. Alt, E, S, F
D. Alt, H, V, V
Correct Answer: A
Rationale:
The legacy shortcut Alt, E, S opens the Paste Special dialog, and T selects Formats. Alt, E, S, V
pastes Values, and Alt, E, S, F pastes Formulas.
Q2 Question 2 of 75
Q2. A modeler wants to select an entire column of data quickly using the keyboard. What is the
correct shortcut to highlight the active column?
A. Shift + Spacebar
B. Ctrl + Spacebar
C. Ctrl + Shift + Down Arrow
D. Alt + Spacebar
Correct Answer: B
Rationale:
Ctrl + Spacebar selects the entire column of the active cell. Shift + Spacebar selects the entire row.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 2 of 40
, Q3 Question 3 of 75
Q3. An associate is reviewing a financial model and wants to see which cells feed into the active
formula. What keyboard shortcut visually traces the precedents of the active cell?
A. Ctrl + [
B. Alt, M, D
C. Alt, M, P
D. F5
Correct Answer: C
Rationale:
Alt, M, P triggers the Trace Precedents command, drawing blue arrows to the source cells. Alt, M, D
traces dependents.
Q4 Question 4 of 75
Q4. A user wants to enter edit mode for the currently selected cell to modify a formula without
using the mouse. What key should the user press?
A. F12
B. F4
C. F9
D. F2
Correct Answer: D
Rationale:
Pressing F2 enters edit mode for the active cell, placing the cursor at the end of the formula. F4
toggles absolute and relative references.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 3 of 40
, Q5 Question 5 of 75
Q5. When formatting a large dataset, an analyst wants to open the Format Cells dialog box
instantly. What keyboard shortcut should be used?
A. Ctrl + 1
B. Ctrl + Shift + F
C. Alt + H + F
D. Ctrl + 5
Correct Answer: A
Rationale:
Ctrl + 1 is the standard shortcut to open the Format Cells dialog box in Excel. The other options do
not directly open this comprehensive menu.
Q6 Question 6 of 75
Q6. An analyst has hidden several rows in a worksheet but wants to switch to a more
professional method that allows other users to expand and collapse the rows easily. What
feature should the analyst use?
A. Custom Views
B. Group (Shift + Alt + Right Arrow)
C. AutoFilter
D. Data Validation
Correct Answer: B
Rationale:
Grouping rows (Shift + Alt + Right Arrow) creates a collapsible +/- toggle on the left margin, which is
the Wall Street Prep best convention over hiding rows.
Excel Crash Course — 2026/2027 | Passing Score: 80% | Page 4 of 40
