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

pic1

AutoFill the Formula

You can use AutoFill to copy the formula to all of the Cells in Row 13 from Column A through Column G.

 

6. Try it: AutoFill the Formula

Select Cell A13.

Use the AutoFill handle to copy the formula to B13 through G13.
 

What Do You See? The Total Row in a Table has options. When you click on a formula in the Total Row, you can choose which function you would like to use.

 

Keep going...

Formulas ->AutoSum ->Sum