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
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
