Quiz%201.girl%20scouts - CS&E 2111 QUIZ#1 Autumn 2016...

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

CS&E 2111 QUIZ #1 – Autumn 2016Please Circle if you are in the Distance Learning ClassDLName: ______________________/100Lab Time: _____________You should only have one answer for each problem on your answer sheet. If you have more, be sure to circle the correct answer or it will not be graded!Use cell references whenever possible.All cell phones should be put away and set on vibrate or 5 points will be deductedWhen time is called you must lay down your pencil IMMEDIATELY or 5 points will be deducted.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)EXCEL SYNTAXFunctionsAVERAGE(number1, [number2]…)AVERAGEIF(range, criteria, [average_range])COUNT(value1, [value2],…)COUNTIF(range, criteria)ROUND(number,num_digits)SMALL(array, k)LARGE(array, k)SUM(number1, [number2],…)SUMIF(range, criteria, [sum_range])

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture