Wall Street Prep: Excel Crash Course Formulas

WALL STREET PREP: EXCEL CRASH COURSE FORMULAS
=AVERAGE(number1,[number2],...) - correct answer ✔✔ Average Function
=IF(logical test, [value if true], [value if false]) - correct answer ✔✔ Simple IF Function
=IFS(logical test n, value if true n, value if false n) - correct answer ✔✔ IFS Function
=IFERROR(value, value_if_error) - correct answer ✔✔ IFERROR Function
=EOMONTH(start_date,months) - correct answer ✔✔ EOMONTH Function
=EDATE(start date,months) - correct answer ✔✔ EDATE Function
=ISNUMBER(value) - correct answer ✔✔ ISNUMBER Function
=ISTEXT(value) - correct answer ✔✔ ISTEXT Function
=YEARFRAC(start_date,End_date,Basis) - correct answer ✔✔ YEARFRAC Function
=DATE(year, month, day) - correct answer ✔✔ DATE Function
=DAY(Serial Number) - correct answer ✔✔ DAY Function
=MONTH(serial number) - correct answer ✔✔ MONTH Function =YEAR(Serial Number) - correct answer ✔✔ YEAR Function
=AND(logical1,[logical2],...) - correct answer ✔✔ AND Function
=OR(logical1,[logical2],...) - correct answer ✔✔ OR Function
=HLOOKUP(Lookup Value, Table Array, Row Index Number, [Range Lookup]) - correct answer ✔✔ HLOOKUP (Horizontal Lookup) Function
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - correct answer ✔✔ VLOOKUP (Vertical Lookup) Function
=XLOOKUP(lookup_value,lookup_array,return_array,[if not found]) - correct answer ✔✔ XLOOKUP (Excel
Lookup) Function
=XMATCH(lookup_value,lookup_array,[match_mode],[search_mode]) - correct answer ✔✔ XMATCH Function
=INDIRECT(referencetext) - correct answer ✔✔ INDIRECT Function
=INDEX(array,row_num,[column_num]) - correct answer ✔✔ INDEX Function
=CHOOSE(index_num,value1,value2,value n) - correct answer ✔✔ CHOOSE Function
=OFFSET(reference,rows,columns,[height,[width]) - correct answer ✔✔ OFFSET Function
=ADDRESS(row_num,col_num,[abs_num],[a1],[sheet text]) - correct answer ✔✔ ADDRESS Function
=COLUMN(reference) - correct answer ✔✔ COLUMN Funtion