Excel Crash Course Exam Questions
and Answers (2026) | Latest Test
Bank with Verified Solutions | Grade
A+
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
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
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
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
When to use HLOOKUP . Answer: When your comparison values are all in a row across
the top of the data table, and you want to look down a specified number of rows
When to use a VLOOKUP . Answer: When your comparison values are located in a col
to the left of a data table and you want to look across a specified number of columns
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
OFFSET . Answer: instead of selecting a whole array, you select a reference point
which is usually the top left hand corner of the array or above the column if only one
column. Then select rows and columns as numbers across and down from the
reference point
MATCH . Answer: returns the relative position (number) of an item in an array that
matches a specified value
and Answers (2026) | Latest Test
Bank with Verified Solutions | Grade
A+
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
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
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
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
When to use HLOOKUP . Answer: When your comparison values are all in a row across
the top of the data table, and you want to look down a specified number of rows
When to use a VLOOKUP . Answer: When your comparison values are located in a col
to the left of a data table and you want to look across a specified number of columns
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
OFFSET . Answer: instead of selecting a whole array, you select a reference point
which is usually the top left hand corner of the array or above the column if only one
column. Then select rows and columns as numbers across and down from the
reference point
MATCH . Answer: returns the relative position (number) of an item in an array that
matches a specified value
