It will go ahead and sum up the scores for all the students just like it did for Jessica Kevin. Holding the left mouse button, you cannot drag your mouse all it down to cell K13 and then let go of the mouse. Select cell K5, and move the mouse to the right bottom quarter of the cell until the icon changes to a fill handle. We are going to use the copy formula ability in Microsoft Excel 2007 to repeat this task. This is great, but how can we copy this formula to the other students data? Let’s see that in our next practice on Excel Formulas Tab. What this function is saying is that we would like to add all the numbers from B5 through J5 and place the result in cell K5.Īfter I pressed the Enter key, Excel 2007 computed the result and placed the total score of 707 in the correct location as visible below. Notice that all functions in Excel start with an equal sign. In addition it placed this function =Sum(B5:J5) in cell K5. You will notice that Microsoft Excel placed a dotted rectangle around the cells from B5 through J5. Click on AutoSum command on the Ribbon under excel formulas tab. Go ahead and click on the cell K6 which would highlight Jessica Kevin’s total points. We have designated column K (Total) for the total scores. We would like to know the total scores achieved by every student across all the assignments and tests.
We will start with the AutoSum command on the Functional Library group under the Formulas Tab in Microsoft Excel.
I have included a screen shot of the students grades data here with the Excel Formulas Tab highlighted in red. We are going to be using a Grading workbook for our lesson today. We have the students listed on the left side while the assignment and test scores are noted across the columns. Let’s go ahead and see the function capabilities of Excel 2007 Formulas Tab in action next.