Critical Thinking Questions Case 1-2 You Are a 7th Grade

Multiple Choice

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. So far, you have entered the names of your students in cells A4 through A11 as well as scores for Test 1 in cells B4 through B11 and Test 2 in cells C4 through C11. Graham is the first student in cell A4. Which of the following is NOT a valid formula for use in cell B13 for finding the average of Test 1?

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)