Midterm A - CSE 2111 Midterm A\/250 Functions AND(logical1[logical2 AVERAGE(number1[number2 AVERAGEIF(range criteria[average_range COUNT(value1[value2

# Midterm A - CSE 2111 Midterm A/250 Functions...

• Test Prep
• 5
• 100% (13) 13 out of 13 people found this document helpful

This preview shows page 1 - 3 out of 5 pages.

CSE 2111 Midterm A ________/250 Functions AND(logical1, [logical2],…) AVERAGE(number1, [number2]…) AVERAGEIF(range, criteria, [average_range]) COUNT(value1, [value2],…) COUNTIF(range, criteria) RANK.EQ(Number, Ref, [Order]) ROUND(number,num_digits) SMALL(array, k) LARGE(array, k) SUM(number1, [number2],…) SUMIF(range, criteria, [sum_range]) AVERAGEIF(range, criteria, [average_range]) MAX(number1, [number2],…) MIN(number1, [number2],…) NOT(logical) OR(logical1, [logical2],…) FV(rate, nper, pmt, [pv], [type]) NPER(rate, pmt, pv, [fv], [type]) PMT(rate, nper, pv, [fv], [type]) PV(rate, nper, pmt, [fv], [type]) RATE(nper, pmt, pv, [fv], [type]) IF(logical_test,[value_if_true],[value_if_false]) HLOOKUP(lookup_value, table_array, row_index_no,[ range_lookup_type]) VLOOKUP(lookup_value, table_array, col_index_no, [range_lookup_type]) SUMIFS(sum_range,criteria_range1,criteria1,…) AVERAGEIFS(average_range,criteria_range1,criteria1,…) COUNTIFS(criteria_range1,criteria,…) Page 1