Wall Street Prep Excel Crash Course Exam 2026: Updated Questions with Detailed Answers

WALL STREET PREP EXCEL CRASH COURSE
EXAM 2026
UPDATED QUESTIONS WITH DETAILED
ANSWERS
1. Auto-width columns to fit the size - ANSWER--Alt + H + O + I


2. Define width of columns - ANSWER--Alt + H + O + W


3. Rename a worksheet - ANSWER--ALT + H + O + R


4. Add worksheet - ANSWER--Alt + H + I + S


5. Freeze and unfreeze panes - ANSWER--Alt + W + F + F


6. Split pane - ANSWER--Alt + W + S


7. Jump from split pane to split pane - ANSWER--F6


8. To navigate outside the cell when in formula - ANSWER--F2


9. Add comment - ANSWER--Alt + N + C2


10.Delete Row/Column - ANSWER--Ctrl -


11.Add row - ANSWER--Ctrl + Shift + +

1|Page

, 12.Paste special - ANSWER--Alt + E + S or Ctrl + Alt + V


13.Transpose - ANSWER--Alt + E + S + E


14.How to get to date format "April-24" - ANSWER--Go to Ctrl + 1, then
Custom, then select mm-yy


15.Remove all borders - ANSWER--Ctrl + Shift + _


16.Trace precedents - ANSWER--Alt + M + P


17.Trace dependents - ANSWER--Alt + M + D


18.Remove arrows - ANSWER--Alt + M + A


19.How to format inputs/hardcodes blue - ANSWER--Go to special (Ctrl +
G), then Custom, select Constants and format text blue


20.Go to special - ANSWER--Ctrl + G


21.Conditional formatting - ANSWER--Alt + O + D or Alt + H + L


22.Custom formatting formula syntax - ANSWER--[positive number
format; negative number format, 0 format]




2|Page