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 =D
Document information
- Uploaded on
- April 13, 2024
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers