WALL STREET PREP: EXCEL CRASH COURSE FORMULAS - Study guides, Class notes & Summaries

Wall Street Prep: Excel Crash Course Formulas Exam Questions and Answers =AVERAGE(number1,[number2],...) - Answer-Average Function =IF(logical test, [value if true], [value if false]) - Answer-Simple IF Function =IFS(logical test n, value if true n, value if false n) - Answer-IFS Function =IFERROR(value, value_if_error) - Answer-IFERROR Function =EOMONTH(start_date,months) - Answer-EOMONTH Function =EDATE(start date,months) - Answer-EDATE Function =ISNUMBER(value) - Answer-I...

=ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function

=AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEXT Function =YEARFRAC(sta...

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 =ISN...

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 =ISN...

Wall Street Prep: Excel Crash Course Formulas =AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEX...

Wall Street Prep: Excel Crash Course Formulas =AVERAGE(number1,[number2],...) - ANSWER-Average Function =IF(logical test, [value if true], [value if false]) - ANSWER-Simple IF Function =IFS(logical test n, value if true n, value if false n) - ANSWER-IFS Function =IFERROR(value, value_if_error) - ANSWER-IFERROR Function =EOMONTH(start_date,months) - ANSWER-EOMONTH Function =EDATE(start date,months) - ANSWER-EDATE Function =ISNUMBER(value) - ANSWER-ISNUMBER Function =ISTEXT(value) - ANSWER-ISTEX...