Practice Test Exam Wall Street Prep Excel Crash Course Formulas

Practice Test Exam 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