Excel for Marketing Managers

Probability with Coins or Dice

Probability
w/ Coins
or Dice

18. Add directions.
    Click on cell E6 and drag to the right to cell G6. Press Ctrl+1 to access the
    Format Cells dialog box. Make the following changes.

a. On the Alignment tab, change Horizontal to Center, and click the box

next to Merge Cells.

b. On the Font tab, change Size to 12.

c. On the Borders tab, select Outline.

d. On the Patterns tab, select Light Yellow from the bottom row.

Click OK to exit. In the merged cell, type in the following:

Press F9 to toss the coin.

19. Remove Excel distractions.
    From the Tools menu, select Options and View. Remove the check marks
    from Gridlines, Row & column headers, and Sheet tabs. Click OK to exit.

Figure 214

Selecting fill color and transpar-

ency level for the oval