Excel for Marketing Managers

Candy Bar Fractions

Candy Bar

Fractions

7. Change the height of row 10.
   Move your cursor to the extreme left edge of row 10. Click on the line be-
   tween rows 10 and 11 and, as you did earlier, change the row height of row
   10 to only 34 pixels.


8. Format B10.
   Click on cell B10 and press Ctrl+1 to access Format Cells. You will make
   six changes:

a. Number tab: Select Fraction; from Type, select “Up to two digits”.

b. Alignment tab: Under Text Alignment, change Horizontal to Center.

c. Font tab: Change Font to Arial and Size to 20.

d. Border tab: Click on Outline under Presets.

e. Patterns tab: Select Pale Yellow from the bottom row.

f. Protection tab: Remove the check mark from Locked. Click OK to exit.

Figure 174

Using AutoSum to add the two rows of Xs entered by the student