Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max
Area and
volume

d. Type in the starting number at C15. In this example, you will use a one

(1).

e. Set up the width formula in column C.

Type in the following formula in C16: =$A$15+C15

f. Set up the length formula in column D.

Type in the following formula in D15: =$C$1-2*C15

Click in D16 and press Ctrl+D to copy down the formula to D16.

g. Set up the area formula in column E.

Type in the following formula in E15: =C15*D15

Click in E16 and press Ctrl+D to copy down the formula to E16.

h. Select C16-E16; drag the mouse to copy the formulas down to C63-E63.

7. Find the maximum value.
   Select C65-D65 and right-click. Select Format Cells and make the font
   Ariel, 10 pt, bold. Make the horizontal alignment right-aligned and merge
   the cells. Enter the following text: Maximum Value:
   Type in the following formula in E65: =MAX(E15:E63)