Calculate the Totals

Adding a Total Row to the Table is as simple as checking the option.

 

Before You Begin: Click on the Table. The Table Tools should be available.

 

7. Try It: Add a Total Row
Go to Table Tools->Design.

Go to Table Style Options.

Select: Total Row.

 

What Do You See? By default, the Total Row will be added to the bottom of the Table. Microsoft Excel will insert a formula for your Total: $33,540.00.

 

Keep going, OK?

graphic2

graphic3

Exam 77-420 Microsoft Excel 2013
3. Create Tables
3.2 Modify a Table: Insert a Total Row

 

Table Tools->Design ->Table Style Options -> Total Row

 

graphic1
 

 

 ">