QUESTIONS WITH COMPLETE SOLUTIONS –
WALL STREET PREP
◉ 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