The table style option that is useful to display aggregated data when it is checked is the table row. It is an option in excel table where it shows at the bottom of the last records and displays the sum or total or an average of a specified data. To get a total in excel use this function and type it in the cell =SUM(a1,a2) and then press enter.