Excel for Marketing Managers

Probability with Coins or Dice

Probability

w/ Coins

or Dice

13. Set row height for instructions.
    Go to the left edge of the page and click on the 12 in Row 12. Hold down the
    left mouse button and drag down to highlight Rows 12 and 13. Move the
    cursor (which should look like a plus sign with vertical arrows) to the line
    between Rows 13 and 14. Left click and hold and move it down to change
    the row height. When it says 15.00 (20 pixels) let go.


14. Format and enter instructions.
    Move the cursor to cell B12. Left click and drag to the right and down to
    highlight the range B12:C14. 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. Click

the boxes next to Wrap Text and Merge Cells.

b. On the Font tab, select Arial with size 12.

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

d. On the Patterns tab, select Light Yellow. Click OK to exit.

e. In the merged cells, type the following: Press F9 to roll the die.

15. Hide Excel distractions.
    From the Tools menu, select Options → View tab. Uncheck the boxes next
    to Gridlines, Row & column headings, and Sheet tabs. Click OK to exit.

Figure 223

Setting the row height to 20 pixels