Practice Quiz 1 - CSE 2111 Practice Quiz 1 Name/100...

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

CSE 2111 Practice Quiz 1Name: _____________________/100Lecture Time/Day: ____________________Lab Time/Day: _____________________ InstructionsPlease put your name on every page of this quiz.Answers must be legible or they will be marked incorrect. You should only have one answer for each problem. If you have more, be sure to circle the correct answer or it willnot 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)FunctionsAVERAGE(number1, [number2]…)COUNT(value1, [value2],…)COUNTA(value1, [value2],…)COUNTIF(range, criteria)RANK.EQ(Number, Ref, [Order])SMALL(array, k)LARGE(array, k)AVERAGEIF(range, criteria, [average_range])MAX(number1, [number2],…)MIN(number1, [number2],…)SUM(number1, [number2],…)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture