Exam (elaborations)
Wall Street Prep Excel questions with correct answers (verified)Graded A+
Rating
Sold
-
Pages
6
Grade
A+
Uploaded on
17-10-2023
Written in
2023/2024
IF Function - Answer-if(x,y,z) x=criteria y=output if true z= output if false IFERROR - Answer-=IFERROR(value,value_if_error) EOMONTH - Answer-=EOMONTH(start_date,months) EDATE - Answer-EDATE(start_date,months) YEARFRAC - Answer-YEARFRAC(start_date, end_date, basis) returns the proportion of the year between two given dates, the start_date and end_date. 0 or omitted = U.S. 30/360 1 = actual/actual 2 = actual/360 3 = actual/365 4 = European 30/360 DATE - Answer-DATE(year,month,day). Can be used with day(serial number),month,year =IF(C1,C2,C3) - Answer-see if there is anything in cell C1, and if there was, it would output C2, otherwise C3.
Show more
Read less
Institution
Wall Street Prep Excel
Course
Wall Street Prep Excel
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- Wall Street Prep Excel
- Course
- Wall Street Prep Excel
Document information
- Uploaded on
- October 17, 2023
- Number of pages
- 6
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
wall street prep excel questions with correct answ
-
save a file answer alt f s ctrl s alt f asave
-
auto fit row height answer alt h o a alt o r a
-
move the location of sheets answer alt h o m
$9.99
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Get to know the seller
LUCYJONNES
Also available in package deal
Package deal
Excel Crash Course quiz with accurate answers (verified)Graded A+
5
2023
$ 51.45
More info
