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

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

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