Wall Street Prep: Excel Crash Course Formulas Exam Questions and Answers

Wall Street Prep: Excel Crash Course Formulas Exam Questions and Answers =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 =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 =HLOOKUP(Lookup Value, Table Array, Row Index Number, [Range Lookup]) - Answer-HLOOKUP (Horizontal Lookup) Function =VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - Answer-VLOOKUP (Vertical Lookup) Function =XLOOKUP(lookup_value,lookup_array,return_array,[if not found]) - Answer-XLOOKUP (Excel Lookup) Function =XMATCH(lookup_value,lookup_array,[match_mode],[search_mode]) - Answer-XMATCH Function =INDIRECT(referencetext) - Answer-INDIRECT Function =INDEX(array,row_num,[column_num]) - Answer-INDEX Function =CHOOSE(index_num,value1,value2,value n) - Answer-CHOOSE Function =OFFSET(reference,rows,columns,[height,[width]) - Answer-OFFSET Function =ADDRESS(row_num,col_num,[abs_num],[a1],[sheet text]) - Answer-ADDRESS Function =COLUMN(reference) - Answer-COLUMN Funtion =ROW(reference) - Answer-ROW Function =SUMPRODUCT(array1,[array2],[array3],...) - Answer-SUMPRODUCT Function =SUMIF(range, criteria, [sum_range]) - Answer-SUMIF Function =AVERAGEIF(range,criteria,[average_range]) - Answer-AVERAGEIF Function =SUMIFS(range1,criteria_range1,criteria1,etc.) - Answer-SUMIFS Function =AVERAGEIFS(average_range,criteria_range1,criteria1,[criteria_range2,criteria2],...) - Answer-AVERAGEIFS Function =ABS(number) - Answer-absolute value function =CEILING(number,significance) - Answer-CEILING Function =FLOOR(number,signifiance) - Answer-FLOOR Function =COMBIN(number,number_chosen) - Answer-Combination Function =ROUND(number,num_digits) - Answer-ROUND Function =ROUNDUP(number,num_digits) - Answer-ROUNDUP Function =ROUNDDOWN(number,num_digits) - Answer-ROUNDDOWN Function =MIN(number1,[number2],...) - Answer-MIN Function =MAX(number1,[number2],...) - Answer-MAX Function =COUNT(value1,[value2],...) - Answer-COUNT Function =COUNTA(value1,[value2],...) - Answer-COUNTA Function =COUNTIF(range, criteria) - Answer-COUNTIF Function =PV(RATE, NPER,