Quiz 1 Revised - CS&E 2111 QUIZ 1 Spring 2017 Name Lecture...

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

CS&E 2111 QUIZ 1 Spring 2017Name: ______________________Lecture Day: ___________Lecture Time: __________ Lab Day: __________Lab Time: ___________Ques #StudentTotal112253642510623717TOTAL75You 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.No Notes or calculators allowed.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.EXCEL SYNTAXAVERAGE(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])AVERAGEIF(range, criteria, [average_range])MAX(number1, [number2],…)MIN(number1, [number2],…)SUMIFS(sum_range,criteria_range1,criteria1,…)AVERAGEIFS(average_range,criteria_range1,criteria1,…)COUNTIFS(criteria_range1,criteria,…)RANK.EQ(number,ref,[order])1 of 3 pages

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture