CSE200 SP09 KREEVES           ANSWER SHEET QUIZ#1            SEAT# ____________

 

NAME _______________________________________________        Lecture:  TR 1:30-3:18pm 

 

Lab section (check one):            _______ F 1:30-3:18pm             ________ F 3:30-5:18pm

 

ANSWERS TO TRUE/FALSE QUESTIONS. Circle one per question.

 

1.      True     False

 

2.      True     False

 

3.      True     False

 

4.      True     False

 

5.      True     False

 

6.      True     False

 

7.      True     False

 

8.      True     False

 

9.      True     False

Q#

PTS

MINUS

ANSWER

10

4

 

=COUNT(B4:B22)

Can also use columns C, D, and E

No $ allowed

 

11

3

 

=SUM(C4:C22)

Optional $ on row

12

5

 

A.    No

B.     No it will not return the same results. That is, the average will be different if using blank values instead of zeroes. Since blank values are ignored, the sum of the values would be the same (per above), but the number of values to divide it by to make the average would be different i.e. it would count the number of values differently since blanks would be ignored but zeroes would be counted.

 

13

5

 

=C4/$B4

No extra $ allowed

 

14

6

 

=RANK(F4,F$4:F$22,0)

No extra $ allowed

Optional 3rd argument i.e. can be left out since is the default value

 

15

6

 

=ROUND(AVERAGE(I4:K4),0)

Optional $ on column

 

16

4

 

The precision for column L changed due to the round function so there is no decimal portion; whereas the values in column N are formatted to a whole value so the precise value could either be actually less than the formatted value, more than the formatted value, or the same, thus giving positive, negative, and zero values in column N respectively.

 

 

17

6

 

=LARGE(F$4:F$22,$P4)

No extra $ allowed

 

 

 

 

SCORE _____________/50