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?

 

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

 

 

 

 ">