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