Wall Street Prep Excel Crash Course Formulas Exam 64 Questions with Verified Answers
=AVERAGE(number1,[number2],...) - CORRECT ANSWER Average
... [Show More] 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],...) - CORRECT ANSWER AND Function
=OR(logical1,[logical2],...) - CORRECT ANSWER OR Function
=HLOOKUP(Lookup Value, Table Array, Row Index Number, [Range Lookup]) - CORRECT ANSWER HLOOKUP (Horizontal Lookup) Function
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - CORRECT ANSWER VLOOKUP (Vertical Lookup) Function
=XLOOKUP(lookup_value,lookup_array,return_array,[if not found]) - CORRECT ANSWER XLOOKUP (Excel Lookup) Function
=XMATCH(lookup_value,lookup_array,[match_mode],[search_mode]) - CORRECT ANSWER XMATCH Function
=INDIRECT(referencetext) - CORRECT ANSWER INDIRECT Function
=INDEX(array,row_num,[column_num]) - CORRECT ANSWER INDEX Function
=CHOOSE(index_num,value1,value2,value n) - CORRECT ANSWER CHOOSE Function
=OFFSET(reference,rows,columns,[height,[width]) - CORRECT ANSWER OFFSET Function
=ADDRESS(row_num,col_num,[abs_num],[a1],[sheet text]) - CORRECT ANSWER ADDRESS Function
=COLUMN(reference) - CORRECT ANSWER COLUMN Funtion
=ROW(reference) - CORRECT ANSWER ROW Function
=SUMPRODUCT(array1,[array2],[array3],...) - CORRECT ANSWER SUMPRODUCT Function
=SUMIF(range, criteria, [sum_range]) - CORRECT ANSWER SUMIF Function
=AVERAGEIF(range,criteria,[average_range]) - CORRECT ANSWER AVERAGEIF Function
=SUMIFS(range1,criteria_range1,criteria1,etc.) - CORRECT ANSWER SUMIFS Function
=AVERAGEIFS(average_range,criteria_range1,criteria1,[criteria_range2,criteria2],...) - CORRECT ANSWER AVERAGEIFS Function
=ABS(number) - CORRECT ANSWER absolute value function
=CEILING(number,significance) - CORRECT ANSWER CEILING Function
=FLOOR(number,signifiance) - CORRECT ANSWER FLOOR Function
=COMBIN(number,number_chosen) - CORRECT ANSWER Combination Function
=ROUND(number,num_digits) - CORRECT ANSWER ROUND Function
=ROUNDUP(number,num_digits) - CORRECT ANSWER ROUNDUP Function
=ROUNDDOWN(number,num_digits) - CORRECT ANSWER ROUNDDOWN Function
=MIN(number1,[number2],...) - CORRECT ANSWER MIN Function
=MAX(number1,[number2],...) - CORRECT ANSWER MAX Function
=COUNT(value1,[value2],...) - CORRECT ANSWER COUNT Function
=COUNTA(value1,[value2],...) - CORRECT ANSWER COUNTA Function
=COUNTIF(range, criteria) - CORRECT ANSWER COUNTIF Function
=PV(RATE, NPER, PMT, [FV], [type]) - CORRECT ANSWER Present Value Function
=FV(rate,nper,pmt,[pv],[type]) - CORRECT ANSWER Future Value Function
=NPV(rate,value1,[value2],...) - CORRECT ANSWER Net Present Value Funtion
=XNPV(rate,values,dates) - CORRECT ANSWER XNPV Function
=IRR(values,[guess]) - CORRECT ANSWER internal rate of return function
=XIRR(values,dates,[guess]) - CORRECT ANSWER XIRR Function
=LEN(text) - CORRECT ANSWER LEN Function
=LEFT(text,[num_chars]) - CORRECT ANSWER LEFT Function
=MID(text,start_num,num_chars) - CORRECT ANSWER MID Function
=PROPER(text) - CORRECT ANSWER PROPER Function
=RIGHT(text,[num_chars]) - CORRECT ANSWER RIGHT Function
=UPPER(text) - CORRECT ANSWER UPPER Function
=TRUNC(number,num_digits) - CORRECT ANSWER TRUNC Function
=SEARCH(Find Text, Within Text, [Start Number]) - CORRECT ANSWER SEARCH Function
=FIND(find_text,within_text,start_num) - CORRECT ANSWER FIND Function
=SUBSTITUTE(Text, Old Text, New Text, [Instance Number]) - CORRECT ANSWER SUBSTITUTE Function
=REPLACE(old_text,start_num,num_chars,new_text) - CORRECT ANSWER REPLACE Function
=CONCATENATE(text1,[text2]) - CORRECT ANSWER CONCATENATE Function
=VALUE(text) - CORRECT ANSWER VALUE Function
=DATEVALUE(date_text) - CORRECT ANSWER DATEVALUE Function
=EOMONTH(start_date,months,6+6*(ROUND(MONTH(serial_number)/12,0))-MONTH(serialnumber)-1) - CORRECT ANSWER Fiscal Half Year Date Problem Solution Formula [Show Less]