Question

I can't figure out the formula for each one?
Home Insert Draw Page Layout Formulas Data Review View 2 E E N DO E Get Add-ins G?- c rv - the slicer e Timeline Link New Comm Plvot Table Recommended Table Pictures Shapes Icons My Add-ins v Recommended 0 vN Maps PivotChart Sparklines Pivot Tables Charts 015 , X fx ACDEFGHIJKLMNOP T U Problem 1: Bernoulli's equation relates the pressure and velocity of a fluid. It states: p+50V2 + pgh = constant where p is the pressure, p is the density, V is the velocity, h is elevation, and g is acceleration due to gravity. In Excel, calculate p if v. 3.68 m/s, p. 72.5 kg/m.s?. - 9.81 m/s, h -2.25 m and constant -2,040.0 kg/ms? PHp V^2y/2+p*gh constant (p'V^2)+2*p*g*h=2(constant-p) p (V^2+2*8*h)=2* (constant-p) p=2*lconstant-p\/\V^2+2*8*h) Subtract p from both sides and multiply by 2 Factor outp from the left side of the equation Divide both sides by (V^2+2*g*h) Create this formula in cell E15, referencing the appropriate cells p= V- - 72.5 kg/m-s? 3.68 m/s 9.81 m/s? 2.25 m 2040 kg/m s is constant P-68.21247!

Answer 1

Since the actual equations are already given with the question, I assume that what you need is the code that has to be typed in excel to get the answer.

Any cell in excel is identified by the letter on the top of the row and the number on the left of the column.

1) In the cell D15, type the following.

=2*(D13-D9)/(D10*D10+2*D11*D12)

and press enter. You will get the answer.(dont miss the = sign or any character.)

2) In the cell D12, type the following.

=(D13*D14)/(D15*D16)

and press enter. You will get the answer.

3) In the cell D17, type the following.

=SQRT(2*(D15-D11)/D12-D13*D14)

and press enter. You will get the answer.

4) In the cell D16, type the following.

=D14*SQRT(1-(D12/D13)*(D12/D13))

and press enter. You will get the answer.

5) In the cell D10, type the following.

=SIN(D8+D9)

and press enter.

In the cell D11, type the following.

=SIN(D8)*COS(D9)

and press enter.

In the cell D12, type the following.

=COS(D8)*SIN(D9)

and press enter.

In the cell D13, type the following.

=D11+D12

and press enter.

If the values in D10 and D13 are equal, type 'yes' in D15