Excel Crash Course Exam Guide: Functions, Shortcuts & Answers (2025/2026)

1 of 12


Excel Crash Course Exam - Wall Street Prep125 Questions And
Answers Updated 2025/2026
EOMONTH (start_ date, months) - ......ANSWER........create monthly date headers by
outputting the last day of a specified month

EDATE (start_date,months) - ......ANSWER........returns the exact date, x months from the
start date

Identify a function in cell D6 that will return the fraction of the year elapsed assuming a
360-day count basis. - ......ANSWER........=YEARFRAC (D4, D5,2)

Identify the formula that will always output a date that is the end-of-month date 3 months
after the date inputted in D5. - ......ANSWER........=EOMONTH(D5,3)

Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "animal
lover" for users who have at least 1 dog and at least one cat, and outputs "lonely person"
when those conditions are not met. - ......ANSWER........=IF(AND(B1>0, B2>0),"animal
lover", "lonely person")

=HLOOKUP (look up value, table range, row number) - ......ANSWER........searches for a
value in the top row of a table or an array of values and then returns a value in the same
column from a row you specify in the table or array

=VLOOKUP (look up value, table range, column number) - ......ANSWER........searches for a
value in the leftmost column of a table or an array of values and then returns a value in the
same row from a column you specify in the table or array

=MATCH (lookup_value, lookup_array, match_type) - ......ANSWER........returns the relative
position of an item in an array that matches a specified lookup value

HLOOKUP w/ MATCH - ......ANSWER........=HLOOKUP (look up value, table range, MATCH
((lookup_value, lookup_array, match_type))

, 2 of 12


VLOOKUP w/ MATCH - ......ANSWER........=VLOOKUP (look up value, table range, MATCH
(lookup_value, lookup_array, match_type), 0)

OFFSET w/ MATCH - ......ANSWER........=OFFSET (reference, MATCH (lookup_value,
lookup_array, match_type) -1, MATCH (lookup_value, lookup_array, match_type) -1)

INDEX w/ MATCH - ......ANSWER........=INDEX (array, MATCH (lookup_value, lookup_array,
match_type), MATCH (lookup_value, lookup_array, match_type))

CHOOSE w/ MATCH - ......ANSWER........=CHOOSE (MATCH (lookup_value, lookup_array,
match_type), values)

INDIRECT w/ MATCH - ......ANSWER........=INDIRECT ("R"&MATCH (lookup_value,
lookup_array, match_type)&"C"&MATCH (lookup_value, lookup_array, match_type),
FALSE)

Address Function - ......ANSWER........=ADDRESS (MATCH (lookup_value, lookup_array,
match_type), column_num)

True - ......ANSWER........true multiplied by an operator equals 1

False - ......ANSWER........false multiplied by an operator equals 0

ABS (number) - ......ANSWER........return absolute value

CEILING (number, significance) - ......ANSWER........round input up to number of
significances

FLOOR (number, significance) - ......ANSWER........round input down to number of
significances

COUNT - ......ANSWER........counts the number of cells that contain numbers within the list
of arguments