WALL STREET PREP EXCEL CRASH COURSE
LATEST VERSION EXAM 2026 FULL
QUESTIONS WITH ACCURATE ANSWERS
GRADED A+
⩥ EOMONTH. Answer: =EOMONTH(start_date, months)
allows you to create monthly date headers, by outputting the last day of
a specified month
start_date: represents a starting date reference
months: represents x number of months before or after the start_date
to output a date x months before a start_date, x should be negative
⩥ EDATE. Answer: =EDATE(start_date, months)
similar to EOMONTH, but the difference is that EDATE returns the
exact date, x months from the start date
,⩥ YEARFRAC. Answer: =YEARFRAC(start_date, end_date, basis)
returns the proportion of the year between two given dates (the
start_date and the end_date)
basis is an optional parameter that represents the number of days per
month/year used to calculate the proportion of the year:
0 or omitted: US 30/360
1: actual/actual
2: actual/360
3: actual/365
4: European 30/360
⩥ DATE. Answer: =DATE(year, month, date) is a function that
combines distinct year, month, and day elements into a valid date
function in Excel
combining this function with DAY(serial number), MONTH(serial
number), and YEAR(serial number) is sometimes helpful for creating
date functions out of disparate data
⩥ cell contents as criteria in IF statements. Answer: a surprisingly useful
criteria used in IF statements is a test of whether a cell has anything in it
ex:
, the IF statement =IF(C1, C2, C3) would see if there is anything in cell
c1, and if there was, it would output C2, otherwise C3
⩥ ISNUMBER and ISTEXT. Answer: both typically embedded within
an IF statement, they test whether there is number or text inside a cell,
respectively
⩥ AND. Answer: =AND(logical1, logical2,...) evaluates to true if all of
its arguments are true; false if one or more arguments is false
⩥ OR. Answer: =OR(logical1, logical2,...) evaluates to true if at least
one argument is true
⩥ HLOOKUP. Answer: =HLOOKUP(lookup_value, table_array,
row_index_number, [range_lookup])
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/array
use HLOOKUP when your comparison values are located in a row
across the top of a table of data, and you want to look down a specified
number of rows
LATEST VERSION EXAM 2026 FULL
QUESTIONS WITH ACCURATE ANSWERS
GRADED A+
⩥ EOMONTH. Answer: =EOMONTH(start_date, months)
allows you to create monthly date headers, by outputting the last day of
a specified month
start_date: represents a starting date reference
months: represents x number of months before or after the start_date
to output a date x months before a start_date, x should be negative
⩥ EDATE. Answer: =EDATE(start_date, months)
similar to EOMONTH, but the difference is that EDATE returns the
exact date, x months from the start date
,⩥ YEARFRAC. Answer: =YEARFRAC(start_date, end_date, basis)
returns the proportion of the year between two given dates (the
start_date and the end_date)
basis is an optional parameter that represents the number of days per
month/year used to calculate the proportion of the year:
0 or omitted: US 30/360
1: actual/actual
2: actual/360
3: actual/365
4: European 30/360
⩥ DATE. Answer: =DATE(year, month, date) is a function that
combines distinct year, month, and day elements into a valid date
function in Excel
combining this function with DAY(serial number), MONTH(serial
number), and YEAR(serial number) is sometimes helpful for creating
date functions out of disparate data
⩥ cell contents as criteria in IF statements. Answer: a surprisingly useful
criteria used in IF statements is a test of whether a cell has anything in it
ex:
, the IF statement =IF(C1, C2, C3) would see if there is anything in cell
c1, and if there was, it would output C2, otherwise C3
⩥ ISNUMBER and ISTEXT. Answer: both typically embedded within
an IF statement, they test whether there is number or text inside a cell,
respectively
⩥ AND. Answer: =AND(logical1, logical2,...) evaluates to true if all of
its arguments are true; false if one or more arguments is false
⩥ OR. Answer: =OR(logical1, logical2,...) evaluates to true if at least
one argument is true
⩥ HLOOKUP. Answer: =HLOOKUP(lookup_value, table_array,
row_index_number, [range_lookup])
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/array
use HLOOKUP when your comparison values are located in a row
across the top of a table of data, and you want to look down a specified
number of rows
