EXCEL CRASH COURSE EXAM 2026 ACTUAL
TEST PAPER QUESTIONS SOLUTIONS VERIFIED
COMPLETE STUDY PACKAGE
◉ 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
◉ Conditional formatting.
Answer: Alt + O + D or Alt + H + L
◉ Custom formatting formula syntax.
Answer: [positive number format; negative number format, 0
format]
◉ How to out text after a number in custom formatting.
Answer: Use quote marks
TEST PAPER QUESTIONS SOLUTIONS VERIFIED
COMPLETE STUDY PACKAGE
◉ 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
◉ Conditional formatting.
Answer: Alt + O + D or Alt + H + L
◉ Custom formatting formula syntax.
Answer: [positive number format; negative number format, 0
format]
◉ How to out text after a number in custom formatting.
Answer: Use quote marks