Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max

Area and

Volume

He has 100 feet of fencing to make the three sides of the enclosure.

What measurements must he use to get the largest area inside the fence?

f. Select cells A9-H11 and right-click. Format cells as in previous step.

Enter the following text, pressing Alt+Enter at each line break:

Change the amount of fencing by putting a different value in C1.

Does your new answer have any similarities to the original answer to the prob-

lem?

What conclusions or predictions can you draw from these examples?

2. Build a barn six columns wide by eight rows tall.
   Select cells H14-M21 and right-click. Select Format Cells and make the fol-
   lowing settings:

a. Alignment: Set Horizontal and Vertical both to Center; under Text con-

trol, select Merge cells.

b. Font: Select Ariel, bold, 12 point.

Figure 248

Setting up the amount of fencing and other textual front material