EXCEL CRASH COURSE EXAM 2026
COMPREHENSIVE ASSESSMENT SCRIPT
SOLVED QUESTIONS ANSWERS UPDATED
REVIEW SET
◉ 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
COMPREHENSIVE ASSESSMENT SCRIPT
SOLVED QUESTIONS ANSWERS UPDATED
REVIEW SET
◉ 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