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
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
