Complete Table $1$: Constants and Equations, Inputs Complete Table $2$: Calculate Volume of Cylinder

Radius length, entered in cell F$13,$ should begin at $0[ft]$ and increase by increments of $dR$

as defined in Table $1.$ Numbers should be centered and formatted to two decimal

places. The Table should end at cell F$43.$ The list of numbers should change

automatically if $dR$ is updated to a different value.

Using the Volume Equation with Constraint, calculate the Volume of the cylinder $($SLS

rocket$)$ and fill in the rest of Table $2.$ Numbers should be centered and formatted to

two decimal places. The Volume values should change depending upon what is input

for the Constraint C in Table $1.$

Complete Table $3$: Analysis

In cell K$12,$ create a formula to determine the Maximum Volume of the cylinder.

In cell K$13,$ create a formula to determine the Radius $(r)$ corresponding to the Maximum

Volume.

The second column in Table $3$ should be centered with numbers formatted to $2$ decimal

places.

Apply conditional formatting to Table $2$ so that the cells corresponding to the Maximum

Volume and associated Radius r $($with values found in K$12$ and K$13)$ have a light red

background with dark red text. Table $2$ should highlight the results found in Table $3.$

Complete Table $4$: Final Dimensions of SLS rocket and Verification

In cell K$19,$ calculate the SLS rocket height $h$ using the constraint equation in C$15.$

In cell K$20,$ recalculate the SLS rocket volume by using $r$ and $h$ found in Tables $3$ and $4.$

Use the equation shown in cell C$14$ for this calculation.

In cell K$21,$ answer the question "Does the radius exceed the maximum allowed radius

length" with a "YES" or $"$NO$"$ based on the user input from cell C$18.$ Graphing

Graph Cylinder Volume $($V$)$ versus the Radius $(r)$ with proper plotting techniques and move this graph to a new sheet named Volume Graph. Radius should be shown on the horizontal axis. The graph should be formatted so that NO negative values are plotted on the vertical axis representing Volume.

NOTE: The following test cases will be evaluated to verify the accuracy of your spreadsheet. Change your input and verify the outputs to the following test cases:

$\backslash$table$[[$Test Case,C$,$Increment dR$,$Rmax,Vmax,r$,$h$,$rRmax$],[1,140,0\mathrm{.}25,5,3189\mathrm{.}70,4\mathrm{.}75,45\mathrm{.}00,$NO$],[2,160,0\mathrm{.}25,5,4762\mathrm{.}46,5\mathrm{.}25,55\mathrm{.}00,$YES$],[3,160,0\mathrm{.}25,6,4762\mathrm{.}46,5\mathrm{.}25,55\mathrm{.}00,$NO$],[4,160,0\mathrm{.}5,6,4751\mathrm{.}66,5\mathrm{.}50,50\mathrm{.}00,$NO$]]$ SLS dimensions must satisfy the requirement that the sum of the height plus twenty times the radius should equal a user defined value $C.$

What dimensions $r$ and h produce an SLS rocket with the largest volume storage capacity?

In cell C$13,$ enter the user defined value for the Constraint C as $140[$m$].$

In cell C$14,$ write the equation for the Volume of the cylinder as TEXT. Your cell should

contain the following text: $V=r^{2}h$

In cell C$15,$ write the equation for the Constraint as TEXT. Your cell should contain the

following text: $C=h+20r$

In cell C $16,$ write the equation for Volume as TEXT by solving the equation in C $15$ for h

and substituting this expression into the equation for Volume from cell C$14.$ Your cell

should contain the following text: $)$

In cell C$17,$ enter the user defined value for increment in radius, dR as $0\mathrm{.}25[$m$].$

In cell C $18,$ enter the maximum allowable radius length Rmax as $5[$m$].$

The column Value in Table $1$ should be centered. PLEASE SHOW STEP BY STEP.