i will upvote

add to the shown google sheet

1. (3 pts) Create a formula in cell B4 that converts US cubic feet (ft? to cubic meters (m). You can use the Internet to find the conversion formula. The formula in your Google sheet should compute a new value of the volume in B4 when the value of the desired volume in cell B3 changes. 2. (10 points) Fill in the rectangular array of cells B9 through 013 with a computation of the volume for the diameters in row 9 and heights in column A. In other words, create the formulas in the table such that Cell B9 uses the diameter in B18 and the height in A9 Cell D9 uses the diameter in D8 and the height in A9 Cell C13 uses the diameter in C8 and the height in A13 etc. In other words, fill out all cells between B19 and D13. Values in these cells should all be in m? 3. (5 pts) Generate one plot of volume versus height for all tank diameters 4. (5 pts) Identify all the cells (by highlighting them in light blue), that correspond to volumes that satisfy the target tank sizing objective, in other words volumes that are > the value in cell B4 . . 3. Desired volume 11.3628 ft^3 4. m^3 5 6 7 diameters (cm) 60 8 height (cm) 75 5 90 9 50 10 70 90 12 110 125 13 14 15 16 17 18 19 20 21 22 22