Microsoft Office Tutorials and References
In Depth Information
=((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 follow-
ing formula returns the surface of a sphere, the radius of which is in a cell named radius:
To calculate the volume of a sphere, multiply the cube of the radius by 4 times Π and then divide by 3. The fol-
lowing formula calculates the volume of a sphere. The cell named radius contains the sphere's radius.
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 rectangular solid
The following formula calculates the surface of a rectangular solid using cells named height, width , and length :
=(length*height*2)+(length*width*2)+(width*height*2)
To calculate the volume of a rectangular solid, multiply the height by the width by the length :
=height*width*length
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