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)
 
Search JabSto ::




Custom Search