Excel Crash Course Exam Questions
with 100% Correct Answers
Auto-width columns to fit the size - ✔✔Alt + H + O + I
Define width of columns - ✔✔Alt + H + O + W
Rename a worksheet - ✔✔ALT + H + O + R
Add worksheet - ✔✔Alt + H + I + S
Freeze and unfreeze panes - ✔✔Alt + W + F + F
Split pane - ✔✔Alt + W + S
Jump from split pane to split pane - ✔✔F6
To navigate outside the cell when in formula - ✔✔F2
Add comment - ✔✔Alt + N + C2
Delete Row/Column - ✔✔Ctrl -
Add row - ✔✔Ctrl + Shift + +
Paste special - ✔✔Alt + E + S or Ctrl + Alt + V
Transpose - ✔✔Alt + E + S + E
How to get to date format "April-24" - ✔✔Go to Ctrl + 1, then Custom, then
select mm-yy
Page 1 of 9
©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025.
, Remove all borders - ✔✔Ctrl + Shift + _
Trace precedents - ✔✔Alt + M + P
Trace dependents - ✔✔Alt + M + D
Remove arrows - ✔✔Alt + M + A
How to format inputs/hardcodes blue - ✔✔Go to special (Ctrl + G), then Custom,
select Constants and format text blue
Go to special - ✔✔Ctrl + G
Conditional formatting - ✔✔Alt + O + D or Alt + H + L
Custom formatting formula syntax - ✔✔[positive number format; negative
number format, 0 format]
How to out text after a number in custom formatting - ✔✔Use quote marks
How to align positive numbers with negative numbers in custom formats -
✔✔Put a ) after the positive number format, it will appear as a space
Zoom in and out - ✔✔Ctrl + Alt + +/-
In custom formatting, what should you use instead of 0s to ensure commas only
appear in the thousands - ✔✔#
What function is the same as EOMONTH but for a specific date? - ✔✔EDATE
Page 2 of 9
©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025.
with 100% Correct Answers
Auto-width columns to fit the size - ✔✔Alt + H + O + I
Define width of columns - ✔✔Alt + H + O + W
Rename a worksheet - ✔✔ALT + H + O + R
Add worksheet - ✔✔Alt + H + I + S
Freeze and unfreeze panes - ✔✔Alt + W + F + F
Split pane - ✔✔Alt + W + S
Jump from split pane to split pane - ✔✔F6
To navigate outside the cell when in formula - ✔✔F2
Add comment - ✔✔Alt + N + C2
Delete Row/Column - ✔✔Ctrl -
Add row - ✔✔Ctrl + Shift + +
Paste special - ✔✔Alt + E + S or Ctrl + Alt + V
Transpose - ✔✔Alt + E + S + E
How to get to date format "April-24" - ✔✔Go to Ctrl + 1, then Custom, then
select mm-yy
Page 1 of 9
©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025.
, Remove all borders - ✔✔Ctrl + Shift + _
Trace precedents - ✔✔Alt + M + P
Trace dependents - ✔✔Alt + M + D
Remove arrows - ✔✔Alt + M + A
How to format inputs/hardcodes blue - ✔✔Go to special (Ctrl + G), then Custom,
select Constants and format text blue
Go to special - ✔✔Ctrl + G
Conditional formatting - ✔✔Alt + O + D or Alt + H + L
Custom formatting formula syntax - ✔✔[positive number format; negative
number format, 0 format]
How to out text after a number in custom formatting - ✔✔Use quote marks
How to align positive numbers with negative numbers in custom formats -
✔✔Put a ) after the positive number format, it will appear as a space
Zoom in and out - ✔✔Ctrl + Alt + +/-
In custom formatting, what should you use instead of 0s to ensure commas only
appear in the thousands - ✔✔#
What function is the same as EOMONTH but for a specific date? - ✔✔EDATE
Page 2 of 9
©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025.
