Wall Street Prep Excel questions with correct answers (verified)Graded A+
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.
Geschreven voor
- Instelling
- Wall Street Prep Excel
- Vak
- Wall Street Prep Excel
Documentinformatie
- Geüpload op
- 17 oktober 2023
- Aantal pagina's
- 6
- Geschreven in
- 2023/2024
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
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
Ook beschikbaar in voordeelbundel