Excel for Marketing Managers

Probability with Coins or Dice

Probability
w/ Coins
or Dice

10. Format the die face and die face counting cells.
    Click on cell B4. Hold down the left mouse button and move down and to
    the right to highlight the range B4:C10. Click on the Center Text icon on
    the toolbar. Then click on the Borders icon, and select All Borders from the
    drop down menu.


11. Set the row height for the die simulation cell.
    Move your cursor to the left of the page to the line in between rows 2 and 3.
    When it changes to a plus sign with vertical arrows, click the left mouse
    button and move down until the row height reads 48.00 (64 pixels) and let
    go.


12. Format the die simulation cell.
    Click on cell B2, and press Ctrl+1 to open the Format Cells dialog box and
    make the following changes:

a. On the Alignment Tab, change Horizontal and Vertical to Center.

b. On the Font tab, change the Font to Arial and Size to 36.

c. On the Border tab, select Outline from the Presets.

d. On the Pattern tab, select a color for your die. If you choose a dark

color, go back to the Font tab, and change the font color to white so you

can see it. Click OK to exit.

Figure 221

Close the workbook without

saving changes

Figure 222

Setting the row height to 64 pixels