EXCEL CRASH COURSE FROM WALLSTREET PREP EXAM AND PRACTICE EXAM NEWEST ACTUAL EXAM COMPLETE 200 QUESTIONS AND CORRECT DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+/ BRAND NEW!!

1|Page


EXCEL CRASH COURSE FROM WALLSTREET PREP
EXAM AND PRACTICE EXAM NEWEST ACTUAL EXAM
COMPLETE 200 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+/ BRAND NEW!!


=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

, 2|Page




=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


=OR(logical1,[logical2],...) - Answer-OR Function