Excel Crash Course Exam Questions and
Answers Verified Solutions Latest
Update
Question:
Define width of columns .
Answer:
Alt + H + O + W
Question:
Rename a worksheet .
Answer:
ALT + H + O + R
Question:
Add worksheet .
Answer:
Alt + H + I + S
Question:
Freeze and unfreeze panes .
Answer:
Alt + W + F + F
Question:
Split pane .
Answer:
Alt + W + S
,Question:
Jump from split pane to split pane .
Answer:
F6
Question:
To navigate outside the cell when in formula .
Answer:
F2
Question:
Add comment .
Answer:
Alt + N + C2
Question:
Delete Row/Column .
Answer:
Ctrl
Question:
Add row .
Answer:
Ctrl + Shift + +
Question:
Paste special .
Answer:
Alt + E + S or Ctrl + Alt + V
, Question:
Transpose .
Answer:
Alt + E + S + E
Question:
How to get to date format "April-24" .
Answer:
Go to Ctrl + 1, then Custom, then select mm-yy
Question:
Remove all borders .
Answer:
Ctrl + Shift + _
Question:
Trace precedents .
Answer:
Alt + M + P
Question:
Trace dependents .
Answer:
Alt + M + D
Question:
Remove arrows .
Answer:
Alt + M + A
Answers Verified Solutions Latest
Update
Question:
Define width of columns .
Answer:
Alt + H + O + W
Question:
Rename a worksheet .
Answer:
ALT + H + O + R
Question:
Add worksheet .
Answer:
Alt + H + I + S
Question:
Freeze and unfreeze panes .
Answer:
Alt + W + F + F
Question:
Split pane .
Answer:
Alt + W + S
,Question:
Jump from split pane to split pane .
Answer:
F6
Question:
To navigate outside the cell when in formula .
Answer:
F2
Question:
Add comment .
Answer:
Alt + N + C2
Question:
Delete Row/Column .
Answer:
Ctrl
Question:
Add row .
Answer:
Ctrl + Shift + +
Question:
Paste special .
Answer:
Alt + E + S or Ctrl + Alt + V
, Question:
Transpose .
Answer:
Alt + E + S + E
Question:
How to get to date format "April-24" .
Answer:
Go to Ctrl + 1, then Custom, then select mm-yy
Question:
Remove all borders .
Answer:
Ctrl + Shift + _
Question:
Trace precedents .
Answer:
Alt + M + P
Question:
Trace dependents .
Answer:
Alt + M + D
Question:
Remove arrows .
Answer:
Alt + M + A