EXCEL CRASH COURSE EXAM
PREMIUM TEST BANK WITH EXPERT
SOLUTIONS
◉ 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
PREMIUM TEST BANK WITH EXPERT
SOLUTIONS
◉ 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