Critical Thinking Questions

Short Answer

Critical Thinking Questions
Case 1-2
You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far.
Which of the following is NOT a valid formula for use in cell B13 for finding the average of the test?
a. =(B4+B5+B6+B7+B8+B9+B10+B11)/8
b. =SUM(B4:B11)/8
c. =(B4+B5+B6+B7+B8+B9+B10+B11)/COUNT(B4:B11)
d. =AVG(B4:B11)