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...

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas

Formulas ->AutoSum ->Sum