EXCEL CRASH UPDATED ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS COMPLETE STUDY GUIDE

EXCEL CRASH UPDATED ACTUAL EXAM
QUESTIONS AND CORRECT ANSWERS
COMPLETE STUDY GUIDE

●● 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