Wall Street Prep: Excel Crash Course Formulas Exam Questions with Correct Answers

=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],...)