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)

Question

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)

Quizplus · Accepted Answer

The Answer of 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)