Excel for Marketing Managers

Magic Squares

Magic
Squares

however, when you click on the AutoSum icon, you should see =SUM(D8:F8).

When you have changed the font formatting, click the fill handle and pull

down to cell G10 to copy the formula and formats.

8. Click on cell C11 and type in the following formula: =D10+E9+F8
   Press Enter.


9. Click on cell G11, and type in the following formula: =D8+E9+G10
   Press Enter.


10. Change the formatting in cell C11 and copy down to G11.

a. Right-click on cell D11 and select Format Cells. Select Alignment, and

set Horizontal and Vertical to Center. Next select Font, and select Arial

and 20. Click on the down arrow in the Color box, and select Red. Click

OK to exit.

Figure 138

Selecting which cells’

formula and formats

to copy

Figure 139

Entering desired

formula in cell C11