Excel for Marketing Managers

Magic Squares

Magic

Squares

5. Format D11.
   Right-click on cell D11 and select Format Cells. Select Alignment, and set
   Horizontal and Vertical to center. Next set Font to Arial and Size to 20.
   Click on the down arrow in the Color box, and select Blue from the second
   row. Now click OK to exit.


6. Copy down D11’s formula and formatting.
   Left-click on the fill handle in the lower right corner of cell D11, and drag to
   the right to F11.


7. Use AutoSum on G8 and apply previous formatting; copy down to G10.
   Go to cell G8 and repeat Steps 4 (AutoSum) and 5 (formatting). For Step 4,

Figure 136

Configuring text font and

color

Figure 137

Dragging fill handle to copy formula and formats