Wall Street Prep Actual Exams Compilation 2026/2027 Actual Exam | Complete Bundle with Questions & Correct Answers with Detailed Rationales | Pass Guaranteed - A+ Graded

1



Wall Street Prep Actual Exams Compilation
2026/2027 Actual Exam | Complete Bundle with
Questions & Correct Answers with Detailed
Rationales | Pass Guaranteed - A+ Graded
Exam 1: Excel Crash Course
Q1: The keyboard shortcut to "Save As" a workbook in Excel is:

A. Ctrl + S

B. F12 [CORRECT]

C. Ctrl + Shift + S
D. Alt + F4



Correct Answer: B

Rationale: F12 opens the "Save As" dialog box directly. Ctrl + S performs a standard Save. Ctrl +
Shift + S is often used for "Save As" in browsers but not the primary Excel shortcut.



Q2: Which shortcut allows you to edit the active cell directly?

A. F2 [CORRECT]
B. F4
C. F5

D. Enter



Correct Answer: A

Rationale: Pressing F2 allows you to edit the contents of the selected cell without clicking into
the formula bar. F4 toggles absolute references, and F5 opens the "Go To" dialog.

,2


Q3: To toggle between relative, absolute, and mixed references (e.g., A1, $A$1, A$1) in a
formula, you would select the cell reference and press:

A. F2

B. F4 [CORRECT]

C. F9

D. Ctrl + `


Correct Answer: B

Rationale: F4 cycles through the reference states. This is essential for locking cells when copying
formulas across rows or columns in financial models.



Q4: The keyboard shortcut to "Paste Special" is:

A. Ctrl + V

B. Ctrl + Alt + V [CORRECT]

C. Alt + E + S + V

D. Ctrl + Shift + V


Correct Answer: B

Rationale: Ctrl + Alt + V opens the Paste Special dialog box. The legacy shortcut Alt + E + S + V
also works but is considered older. Ctrl + V is a standard paste.



Q5: Which formula would you use to look up a value in the leftmost column of a table and return
a value from a column to the right?

A. HLOOKUP

B. VLOOKUP [CORRECT]

C. INDEX

D. MATCH

,3


Correct Answer: B

Rationale: VLOOKUP (Vertical Lookup) searches down the first column of a range for a key and
returns the value of a specified cell in the row found. HLOOKUP searches the first row.



Q6: What is the primary limitation of VLOOKUP that is solved by using INDEX/MATCH?

A. VLOOKUP cannot handle numbers

B. VLOOKUP only searches horizontally
C. VLOOKUP can only return values to the right of the lookup column [CORRECT]

D. VLOOKUP is case sensitive


Correct Answer: C

Rationale: VLOOKUP can only look to the right. INDEX/MATCH can look in any direction
(left, right, up, down) and is generally considered more flexible and robust for financial
modeling.



Q7: To select an entire row in Excel, the shortcut is:

A. Ctrl + Space

B. Shift + Space [CORRECT]

C. Ctrl + A
D. Shift + Arrow Key



Correct Answer: B

Rationale: Shift + Space selects the entire row. Ctrl + Space selects the entire column.



Q8: Which shortcut inserts a new worksheet?

A. Shift + F11 [CORRECT]
B. Ctrl + N
C. Alt + Insert

, 4


D. F11



Correct Answer: A

Rationale: Shift + F11 inserts a new worksheet tab. F11 creates a chart sheet. Ctrl + N creates a
new workbook.



Q9: To quickly highlight all cells referenced by a formula (precedents), you use:
A. Ctrl + [

B. Ctrl + ]
C. Trace Dependents

D. Ctrl + Shift + {



Correct Answer: A

Rationale: Ctrl + [ selects all cells directly referenced by the active cell's formula (direct
precedents). Ctrl + ] selects dependents.


Q10: The IF function syntax is =IF(logical_test, value_if_true, value_if_false). If A1 is 10, what
will =IF(A1>5, "Yes", "No") return?

A. 10
B. No

C. Yes [CORRECT]

D. TRUE



Correct Answer: C

Rationale: Since 10 is greater than 5, the logical test is true, so the function returns the
"value_if_true" argument, which is "Yes".


Q11: To calculate the internal rate of return (IRR) for a series of cash flows, you would use the: