# CSE 2111 Midterm - CSE 2111 Midterm Spring 2017 TESTING...

• Assessment
• 7
• 83% (18) 15 out of 18 people found this document helpful

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

CSE 2111 Midterm Spring 2017TESTING CENTER STUDENTSName: ______________________/250Lecture Time/Day: ____________________Lab Time/Day: _____________________ InstructionsNo notes or calculators may be used.Answers must be legible or they will be marked incorrect. If you have more than one answer for a question, be sure to circle the correct answer or it will not be graded!Use cell references whenever it makes sense to do so.In accordance with The Ohio State University Code of Student Conduct, I certify that:I have received no aid on this quiz from any other personI have not given anyone aid on this quizI have not made any copies of this quizI shall NOT discuss the contents of this quiz with anyone who has not already taken this quizSigned: _________________________________ (NO SIGNATURE -5 POINTS)1.352.303.404.355.406.407.30Total:250Page 1
FunctionsAND(logical1, [logical2],…)AVERAGE(number1, [number2]…)COUNT(value1, [value2],…)COUNTA(value1, [value2],…)COUNTIF(range, criteria)RANK.EQ(Number, Ref, [Order])ROUND(number,num_digits)SMALL(array, k)LARGE(array, k)SUM(number1, [number2],…)SUMIF(criteria_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])IFERROR(value, value_if_error)HLOOKUP(lookup_value, table_array, row_index_no,[ range_lookup_type])