Wall Street Prep: Excel Crash Course Formulas Exam Questions & Answers 100% Pass
=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(start_date,End_date,Basis) - ANSWER-YEARFRAC Function =DATE(year, month, day) - ANSWER-DATE Function =DAY(Serial Number) - ANSWER-DAY Function =MONTH(serial number) - ANSWER-MONTH Function =YEAR(Serial Number) - ANSWER-YEAR Function =AND(logical1,[logical2],...) - ANSWER-AND Function
Written for
- Institution
- Wall Street Prep: Excel Crash Course Formulas
- Course
- Wall Street Prep: Excel Crash Course Formulas
Document information
- Uploaded on
- June 3, 2024
- Number of pages
- 5
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wall street prep excel crash course formulas exa
-
wall street prep excel crash course stuvia
-
averagenumber1number2 answer average f
Also available in package deal