Excel for Marketing Managers

Probability with Coins or Dice

Probability
w/ Coins
or Dice

10. Now you can make this workbook look a little nicer.
    Close the workbook. When Excel asks “Do you want to save the changes
    you made to....” select No. Now re-open the file, but do not press F9 until
    you have saved any new additions to the file.


11. Format the head and tail count cells.
    Click on Cell E4. Hold down the left mouse button and drag left and down
    to highlight the range E4:G5. On the Tool bar, click on the Center text icon.
    Then click on the arrow next to the Border icon and select All Borders from
    the drop down menu.


12. Set the row height for the coin simulation.
    Move your cursor to the left until it is on the line between rows 1 and 2.
    The cursor will change to a plus sign with vertical arrows. Left-click and
    move down, and watch as the row height changes. When the height equals
    48.00 (64 pixels) stop.

Figure 208

Do not save changes!

Figure 209

Selecting All Borders