Exam (elaborations)
Wall Street Prep: Excel Crash Course Formulas questions with correct answers
Rating
Sold
-
Pages
5
Grade
A+
Uploaded on
14-02-2023
Written in
2022/2023
=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
Show more
Read less
Institution
Wall Street Prep: Excel Crash
Course
Wall Street Prep: Excel Crash
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- Wall Street Prep: Excel Crash
- Course
- Wall Street Prep: Excel Crash
Document information
- Uploaded on
- February 14, 2023
- Number of pages
- 5
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
averagenumber1
-
number2
-
correct answer average function iflogical test
-
value if true
-
value if false correct answer simple if function
$6.49
Get access to the full document:
Wrong document? Swap it for free
Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
