Observe that it went ahead and computed the average (37.55) and placed the end result in cell B15, Sweet! It even has a links to the Excel Help section if you need more explanation. You can see some additional information on this dialog box. Microsoft Excel 2007 is smart enough to pick cells B5 through B14 (adjacent cells), the scores for Chapter 1 assignment. You will get the Function Arguments dialog box next. Go ahead and type Average in the search text box and then click OK. This time we are going to click on the Excel Formulas Tab and select Insert Function command which will launch Insert function dialog box as shown below. We’ll be adding this information in row 15. Next we would like to compute the Average for all the class assignments and the test scores. Very nice! If you prefer using the keyboard you could’ve done the same thing by using copy (Ctrl+C) and paste (Ctrl+V) commands.

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.

Excel 2007 tutorial video download