Edit the Total Row Look at the Total Row: it has a summary function. You can change the operation from Sum to Average, Count, Max, Min or any of the options available in the extensive Excel library.   8. Try It: Edit the Total Row Function Select: Cell H70. In this example, it is the Cell with the Total formula.   Select a Function: Average.   What Do You See? The average price will be calculated.   Memo to Self: How would someone reading your spreadsheet know that this is the Average, and not the Sum? Labels, Labels, Labels.

Table Tools->Design ->Table Style Options -> Total Row Exam 77-882: Microsoft Excel 2010 Core 3. Formatting Cells and Worksheets 3.1. Apply and modify cell formats: Calculate data in a table