Microsoft Office Tutorials and References

In Depth Information

=((parallel side 1+parallel side 2)*height)/2

Calculating the area of a triangle

To calculate the area of a triangle, multiply the base by the height and then divide by 2. The following formula

calculates the area of a triangle, using cells named
base
and
height:

=(base*height)/2

Calculating the surface and volume of a sphere

To calculate the surface of a sphere, multiply the square of the radius by Π and then multiply by 4. The follow-

ing formula returns the surface of a sphere, the radius of which is in a cell named
radius:

=PI()*(radius^2)*4

To calculate the volume of a sphere, multiply the cube of the radius by 4 times Π and then divide by 3. The fol-

lowing formula calculates the volume of a sphere. The cell named
radius
contains the sphere's radius.

=((radius^3)*(4*PI()))/3

Calculating the surface and volume of a cube

To calculate the surface area of a cube, square one side and multiply by 6. The following formula calculates the

surface of a cube using a cell named
side,
which contains the length of a side of the cube:

=(side^2)*6

To calculate the volume of a cube, raise the length of one side to the third power. The following formula returns

the volume of a cube, using a cell named
side:

=side^3

Calculating the surface and volume of a rectangular solid

The following formula calculates the surface of a rectangular solid using cells named
height, width
, and
length
:

=(length*height*2)+(length*width*2)+(width*height*2)

To calculate the volume of a rectangular solid, multiply the height by the width by the length
:

=height*width*length

Calculating the surface and volume of a cone

The following formula calculates the surface of a cone (including the surface of the base). This formula uses

cells named
radius
and
height: