EXCEL CRASH COURSE EXAM 2026 LATEST VERSION FROM WALL STREET QUESTIONS AND 100% CORRECT ANSWERS

1|Page



EXCEL CRASH COURSE EXAM 2026 LATEST VERSION
FROM WALL STREET QUESTIONS AND 100%
CORRECT ANSWERS

Auto-width columns to fit the size ......ANSWER......Alt + H + O + I


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



pg. 1

, 2|Page


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

pg. 2