Microsoft Office Tutorials and References

In Depth Information

**Area, Surface, Circumference, and Volume Calculations**

The radius of a circle is equal to one-half of the diameter.

To calculate the circumference of a circle, multiply the diameter of the circle by

Π

. The following

formula calculates the circumference of a circle using a cell named
diameter:

=diameter*PI()

The diameter of a circle is the radius times 2.

Calculating the area of a trapezoid

To calculate the area of a trapezoid, add the two parallel sides, multiply by the height, and then

divide by 2. The following formula calculates the area of a trapezoid, using cells named
parallel

side 1, parallel side 2,
and
height:

=((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 following 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 following formula calculates the volume of a sphere. The cell named
radius
contains the

sphere’s radius.

Π

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