Excel for Marketing Managers

Demonstrating and Comparing Fractions with Charts

Comparing

Fractions

in Charts

b. Select Tools → Protection → Protect Sheet. Remove the check mark

from Select locked cells and click OK.

5. To use the worksheet, type in two different fractions in each of the two
   cells. Have the students determine which is larger, then press F9 to display
   the two charts.

Figure 246

Using Format Cells → Protection

tab to hide the formula for the

left-most fraction

Figure 247

Preventing students from selecting

locked cells