The worksheet shown below was designed to calculate the total pressure felt by an object submerged in a fluid as a function of the depth the object is submerged. The user will enter the surface pressure (in units of atmospheres), specific gravity of the fluid, and the gravity of the planet (in units of meters per second squared) - all user input is shown in red. The worksheet will calculate the surface pressure in units of pascals, density of the fluid in kilograms per cubic meter, and depth in units of feet - all conversions are shown in orange. Finally, the worksheet will calculate the total pressure in units of atmospheres. (a) What formula should be typed in cell C8 to convert the surface pressure in cell C4 from atmospheres to pascals? A B C D *** 4 Surface Pressure (Psurface) 2 [atm] 5 6 Specific Gravity of Fluid Gravity (SG) 1.26 (g) 9.8 [-] [m/s^2] 7 8 Surface Pressure (Psurface) = C4 101325 [Pa] (b) What formula should be typed in cell C9 to determine the density in units of kilograms per cubic meter? *** B C D 4 5 Surface Pressure Specific Gravity of Fluid (Psurface) 2 [atm] (SG) 1.26 6 Gravity (g) 9.8 [-] [m/s^2] 7 8 Surface Pressure 9 Density of Fluid (Psurface) (p) 202650 [Pa] = C5 1000 [kg/m^3] *** (c) What formula should be typed into cell B12 that can then be copied down Column B to convert the depth from units of feet to units of meters? A B C 11 Depth (H) [ft] Depth (H) [m] Total Pressure (P) [atm] 12 1 = A12/3.28 13 10 14 20 (pasted from B12) (pasted from B12) 15 30 (pasted from B12) (pasted 16 40 from B12) (pasted 17 50 from B12) (pasted 18 60 from B12) (pasted 19 70 from B12) 20 80 (pasted from B12) 21 90 D 22 100 (pasted from B12) (pasted from B12) (d) What formula should be typed into cell C12 that can then be copied down Column C to calculate the total pressure in units of atmospheres? A B C :== 11 Depth (H) [ft] Depth (H) [m] Total Pressure (P) [atm] 12 1 0.31 13 10 3.05 14 20 6.10 15 30 9.15 16 40 12.20 17 50 15.24 18 60 18.29 19 70 21.34 20 80 24.39 21 90 27.44 22 100 30.49 =$C$8+ $C$9 * $C$6* $B$12 = ($C$8+ $C$9 * $C$6* B12)/101325 =C$8 (C$9 C$6 * B$12)*1.01325 =($C9 * $C6* $B12-C8)/760 =C8+C9 C6* B12 =(C$8+C$9 C$6* B$12)*101325 D