age 1 of 31
EXCEL CRASH COURSE EXAM 2025 LATEST VERSION
FROM WALL STREET QUESTIONS AND 100% CORRECT
ANSWERS (BRAND NEW!!)-WSP EXCEL CRASH COURSE
INDEX ......ANSWER........allows you to pinpoint a location of a
return value in an array
CHOOSE ......ANSWER........allows you to choose which value in a
set of values
Auto-width columns to fit the size ......ANSWER........Alt + H + O
+I
Define width of columns ......ANSWER........Alt + H + O + W
Rename a worksheet ......ANSWER........ALT + H + O + R
Add worksheet ......ANSWER........Alt + H + I + S
,age 2 of 31
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
,age 3 of 31
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]
, age 4 of 31
How to out text after a number in custom formatting
......ANSWER........Use quote marks
How to align positive numbers with negative numbers in custom
formats ......ANSWER........Put a ) after the positive number
format, it will appear as a space
Zoom in and out ......ANSWER........Ctrl + Alt + +/-
In custom formatting, what should you use instead of 0s to ensure
commas only appear in the thousands ......ANSWER........#
What function is the same as EOMONTH but for a specific date?
......ANSWER........EDATE
How to output different things depending on if there's text or
numbers in a cell ......ANSWER........IF + ISTEXT functions
Function to turn things into a date ......ANSWER........DATE
EXCEL CRASH COURSE EXAM 2025 LATEST VERSION
FROM WALL STREET QUESTIONS AND 100% CORRECT
ANSWERS (BRAND NEW!!)-WSP EXCEL CRASH COURSE
INDEX ......ANSWER........allows you to pinpoint a location of a
return value in an array
CHOOSE ......ANSWER........allows you to choose which value in a
set of values
Auto-width columns to fit the size ......ANSWER........Alt + H + O
+I
Define width of columns ......ANSWER........Alt + H + O + W
Rename a worksheet ......ANSWER........ALT + H + O + R
Add worksheet ......ANSWER........Alt + H + I + S
,age 2 of 31
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
,age 3 of 31
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]
, age 4 of 31
How to out text after a number in custom formatting
......ANSWER........Use quote marks
How to align positive numbers with negative numbers in custom
formats ......ANSWER........Put a ) after the positive number
format, it will appear as a space
Zoom in and out ......ANSWER........Ctrl + Alt + +/-
In custom formatting, what should you use instead of 0s to ensure
commas only appear in the thousands ......ANSWER........#
What function is the same as EOMONTH but for a specific date?
......ANSWER........EDATE
How to output different things depending on if there's text or
numbers in a cell ......ANSWER........IF + ISTEXT functions
Function to turn things into a date ......ANSWER........DATE
