Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max
Area and
volume

c. Pattern: Select Cell shading Color of Red (left-most column, middle

row). Press Enter.

d. Type in the following text: Barn

3. Build a fence four columns wide by three rows high under the barn.
   Select I22-L24 and right-click. Select Format Cells and make the following
   settings:

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

trol, select Merge cells.

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

c. Border: Select Outline and the thickest solid Line style (one up from

bottom right).

d. Pattern: Select Cell shading Color of Dark Yellow (column three, row

two) and a Pattern of 6.25% Gray (top right). Press Enter.

e. Type in the following text: Area

4. Label the Length and Width.
   Select H22-H24 and right-click. Select Format Cells; make both Horizontal
   and Vertical Text alignment Center and click on Merge cells. Press Enter.
   Type in the following text: Width
   Select I25-L26 and right-click. Make the same settings as above and press
   Enter. Type in the following text: Length