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:
Π