Quiz #4 key
- Sungwook Moon

Form A

1. =dsum(mba, "Interview", C9:D10)
2. TRUE
3. TRUE
4. 4
5. TRUE
6. 0 (I made 4 to be right as well. I intended to give a DCOUNTA function for this question, which I didnt. 4 is the answer if it was DCOUNTA.)
7. =daverage(mba, "GMAT", C9:C10)
8. 15
9. good
10. FALSE
11. 3.2
12. excellent (everyone received 2 points for this question as this lookup function was mentioned very breifly in the class. extra two points for giving a correct answer)
13. 770
14. 4
15. 3


1) 8
2) #N/A (2 points for putting any error messages. For an accurate answer, extra 2 points)


Form B

1. 4
2. TRUE
3. 0 (I made 4 to be right as well. I intended to give a DCOUNTA function for this question, which I didnt. 4 is the answer if it was DCOUNTA.)
4. =daverage(mba, "GMAT", C9:C10)
5. =dsum(mba, "Interview", C9:D10)
6. TRUE
7. TRUE
8. 770
9. 4
10. 3
11. 15
12. good
13. FALSE
14. 3.2
15. excellent (everyone received 2 points for this question as this lookup function was mentioned very breifly in the class. extra two points for giving a correct answer)

1) 8
2) #N/A (2 points for putting any error messages. For an accurate answer, extra 2 points)