WALL STREET PREP: EXCEL CRASH COURSE FORMULAS EXAMS WITH COMPLETE SOLUTIONS

WALL STREET PREP: EXCEL CRASH COURSE
FORMULAS EXAMS WITH COMPLETE SOLUTIONS


=AVERAGE(number1,[number2],...)
Average Function
=IF(logical test, [value if true], [value if false])
Simple IF Function
=IFS(logical test n, value if true n, value if false n)
IFS Function
=IFERROR(value, value_if_error)
IFERROR Function
=EOMONTH(start_date,months)
EOMONTH Function
=EDATE(start date,months)
EDATE Function
=ISNUMBER(value)
ISNUMBER Function
=ISTEXT(value)
ISTEXT Function
=YEARFRAC(start_date,End_date,Basis)
YEARFRAC Function
=DATE(year, month, day)
DATE Function
=DAY(Serial Number)
DAY Function
=MONTH(serial number)
MONTH Function
=YEAR(Serial Number)

, YEAR Function
=AND(logical1,[logical2],...)
AND Function
=OR(logical1,[logical2],...)
OR Function
=HLOOKUP(Lookup Value, Table Array, Row Index Number, [Range Lookup])
HLOOKUP (Horizontal Lookup) Function
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
VLOOKUP (Vertical Lookup) Function
=XLOOKUP(lookup_value,lookup_array,return_array,[if not found])
XLOOKUP (Excel Lookup) Function
=XMATCH(lookup_value,lookup_array,[match_mode],[search_mode])
XMATCH Function
=INDIRECT(referencetext)
INDIRECT Function
=INDEX(array,row_num,[column_num])
INDEX Function
=CHOOSE(index_num,value1,value2,value n)
CHOOSE Function
=OFFSET(reference,rows,columns,[height,[width])
OFFSET Function
=ADDRESS(row_num,col_num,[abs_num],[a1],[sheet text])
ADDRESS Function
=COLUMN(reference)
COLUMN Funtion
=ROW(reference)
ROW Function
=SUMPRODUCT(array1,[array2],[array3],...)
SUMPRODUCT Function
=SUMIF(range, criteria, [sum_range])
SUMIF Function