Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max
Area and
volume

You will create a chart that will calculate the area of the fenced-in enclosure

using all the possible combinations of length and width using an incremental

change of your choice. You will also make a graph to show the change in the

area as the dimensions change.

Creating the Solution

1. Enter and format the text as shown below.

a. Select cells A1-B1 and right-click. Select Format Cells; make the font

Ariel, 10 pt, bold and click on the checkbox next to Merge cells under

Alignment. Press Enter.

Enter the following text: Amount of Fence:

b. In C1, type in 100. You or your students can vary this amount to explore

different scenarios.

c. Select cells J3-K5 and right-click. Select Format Cells; make the font

Ariel, bold, 16 and click on the checkbox next to Merge cells under

Alignment. Press Enter.

Enter the following text, pressing Alt+Enter between words to insert a

line break: Farmer’s Fence:

d. Select cell A3 and right-click. Select Format Cells and make the font

Ariel, 10 pt, bold. Press Enter.

Enter the following text: Instructions:

Make the same settings in A8 and enter the following text:

Further Investigation:

e. Select cells A4-H6 and right-click. Select Format Cells; make the font

Ariel, 10 pt, bold. Click in the checkbox next to Merge cells under Align-

ment and make Vertical alignment Center. Press Enter.

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

A farmer wants to use one side of his barn to make a fenced in area for his

livestock.