Finding Maximum Area and Volume
Finding Max
Area and
Volume- Set up the incrementation value.
a. Select A14-A15 and select both Outside and Inside borders. Set the font
to Ariel, 10 pt, bold and then type in the word Increment in A14.b. Type in the incrementation value in A15. In this case, use a one (1).
Whatever value you choose (1, 0.5, 1/3, etc.) will be used to increment
the rest of the values in this column. This allows you to quickly change
the nature of the series. Using a one (1) has the advantage of producing
an answer that is a whole number.- Build the calculations table.
a. Select C14 down to E63 and right-click. Select Format Cells.b. Set the borders to Outline and Inside.c. Select C14-E14 and set the font to Ariel, 10 pt, bold and then type in
the following words Width, Length, and Area in C14, D14, and E14, re-
spectively.Figure 249
Building and labeling
the barn and fence