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],...)
Escuela, estudio y materia
- Institución
- Wall Street Prep: Excel Crash Course Formulas
- Grado
- Wall Street Prep: Excel Crash Course Formulas
Información del documento
- Subido en
- 1 de septiembre de 2023
- Número de páginas
- 4
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
Documento también disponible en un lote