Excel for Marketing Managers

Magic Squares Magic Squares Select and format the range. Now go to cell D8, left-click and drag right and down to cell F10. You ...

Magic Squares Magic Squares c. Click on the Font tab, and change Font to Arial and Size to 20. d. Click on the Patterns tab, and ...

Magic Squares Magic Squares e. And last (finally!) click on the Protection tab; uncheck the box next to the word Locked. Click o ...

Magic Squares Magic Squares Format D11. Right-click on cell D11 and select Format Cells. Select Alignment, and set Horizontal a ...

Magic Squares Magic Squares however, when you click on the AutoSum icon, you should see =SUM(D8:F8). When you have changed the f ...

Magic Squares Magic Squares b. Now, click on cell C11 and copy (Ctrl+C). Click on cell G11. From the drop down menus, select Edi ...

Magic Squares Magic Squares b. Next, click on the Font tab. Change the Font type to Arial with size 20. Click OK. Click on cell ...

Magic Squares Magic Squares d. Inside the merged cells, type in the following text: Place the numbers 1-9 in the squares below. ...

Magic Squares Magic Squares Set up sheet protections. From the Tools menu, select Protection and Protect Sheet. Uncheck the box ...

Magic Squares Magic Squares Using the Application............................................................................... ...

Magic Squares Magic Squares Excel Extras I had used Magic Squares before, but I discovered quite a bit about them while doing re ...

Coordinate Grid Matching Coordinate Grid Matching Coordinate Grid Matching Opportunity.......................................... ...

Coordinate Grid Matching Coordinate Grid Matching Format cells. Move your cursor to cell A1. Left-click and drag to the right a ...

Coordinate Grid Matching Coordinate Grid Matching Apply conditional formatting to smiley face cell. Click on any of the newly c ...

Coordinate Grid Matching Coordinate Grid Matching c. The box to the right is currently empty. You can have Excel look at the val ...

Coordinate Grid Matching Coordinate Grid Matching Set row height. Move your cursor to Row 8 on the left edge of the screen and ...

Coordinate Grid Matching Coordinate Grid Matching Enter a formula to randomly pick one of the 25 cells in your grid. You will u ...

Coordinate Grid Matching Coordinate Grid Matching b. When finished, press Enter. This tells Excel to look at cell D8. If it con- ...

Coordinate Grid Matching Coordinate Grid Matching strange pictures appearing in the cell. To avoid confusion, watch your typ- in ...

Coordinate Grid Matching Coordinate Grid Matching Copy the formula into the rest of the grid. Go to cell A1, left-click on the ...