Microsoft Office Tutorials and References

In Depth Information

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

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 cone

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

formula uses cells named
radius
and
height:

=PI()*radius*(SQRT(height^2+radius^2)+radius))

To calculate the volume of a cone, multiply the square of the radius of the base by

, multiply by

the height, and then divide by 3. The following formula returns the volume of a cone, using cells

named
radius
and
height:

Π

=(PI()*(radius^2)*height)/3

Calculating the volume of a cylinder

To calculate the volume of a cylinder, multiply the square of the radius of the base by

and then

multiply by the height. The following formula calculates the volume of a cylinder, using cells

named
radius
and
height:

Π

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