Excel Crash Course Exam from Wall
Street Prep | Accurate Questions &
Answers with Solutions Graded A+ 100%
Verified (2026)
‣ Define width of columns . Answer: Alt + H + O + W
‣ Rename a worksheet . Answer: ALT + H + O + R
‣ Add worksheet . Answer: Alt + H + I + S
‣ Freeze and unfreeze panes . Answer: Alt + W + F + F
‣ Split pane . Answer: Alt + W + S
‣ Jump from split pane to split pane . Answer: F6
‣ To navigate outside the cell when in formula . Answer: F2
‣ Add comment . Answer: Alt + N + C2
‣ Delete Row/Column . Answer: Ctrl -
, ‣ Add row . Answer: Ctrl + Shift + +
‣ Paste special . Answer: Alt + E + S or Ctrl + Alt + V
‣ Transpose . Answer: Alt + E + S + E
‣ How to get to date format "April-24" . Answer: Go to Ctrl + 1, then
Custom, then select mm-yy
‣ Remove all borders . Answer: Ctrl + Shift + _
‣ Trace precedents . Answer: Alt + M + P
‣ Trace dependents . Answer: Alt + M + D
‣ Remove arrows . Answer: Alt + M + A
‣ How to format inputs/hardcodes blue . Answer: Go to special (Ctrl +
G), then Custom, select Constants and format text blue
‣ Go to special . Answer: Ctrl + G
‣ Conditional formatting . Answer: Alt + O + D or Alt + H + L
Street Prep | Accurate Questions &
Answers with Solutions Graded A+ 100%
Verified (2026)
‣ Define width of columns . Answer: Alt + H + O + W
‣ Rename a worksheet . Answer: ALT + H + O + R
‣ Add worksheet . Answer: Alt + H + I + S
‣ Freeze and unfreeze panes . Answer: Alt + W + F + F
‣ Split pane . Answer: Alt + W + S
‣ Jump from split pane to split pane . Answer: F6
‣ To navigate outside the cell when in formula . Answer: F2
‣ Add comment . Answer: Alt + N + C2
‣ Delete Row/Column . Answer: Ctrl -
, ‣ Add row . Answer: Ctrl + Shift + +
‣ Paste special . Answer: Alt + E + S or Ctrl + Alt + V
‣ Transpose . Answer: Alt + E + S + E
‣ How to get to date format "April-24" . Answer: Go to Ctrl + 1, then
Custom, then select mm-yy
‣ Remove all borders . Answer: Ctrl + Shift + _
‣ Trace precedents . Answer: Alt + M + P
‣ Trace dependents . Answer: Alt + M + D
‣ Remove arrows . Answer: Alt + M + A
‣ How to format inputs/hardcodes blue . Answer: Go to special (Ctrl +
G), then Custom, select Constants and format text blue
‣ Go to special . Answer: Ctrl + G
‣ Conditional formatting . Answer: Alt + O + D or Alt + H + L