EXCEL CRASH Course WALL Street
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
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