EXCEL CRASH COURSE WALL STREET PREP
CONCLUDING REVIEW SHEET PRACTICE
SOLUTION BUNDLED FULLY VERIFIED
ONE HUNDRED PERCENT PASS
GUARANTEED
⩥ 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])
CONCLUDING REVIEW SHEET PRACTICE
SOLUTION BUNDLED FULLY VERIFIED
ONE HUNDRED PERCENT PASS
GUARANTEED
⩥ 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])
