Surface area of a cone
In geometry, the formula for calculating the surface area of a right cone is:
...Read more
Dave Bruns
Volume of a cone
In geometry, the formula for calculating the volume of a cone is:
...Read more
Surface area of a cylinder
In geometry, the standard formula for calculating the surface area of a cylinder is:
...Read more
Volume of a cylinder
In geometry, the formula for calculating the volume of a cylinder is:
...Read more
Filter to extract matching values
This formula relies on the FILTER function to retrieve data based on a logical test built with the COUNTIF function:
=FILTER(list1,COUNTIF(list2,list1))
working from the inside out, the...Read more
Surface area of a sphere
In geometry, a sphere is defined as the set of points that are all the same distance (r) from a given point in a three-dimensional space. The formula for calculating the surface area of a sphere is:
...Read more
Volume of a sphere
In geometry, a sphere is defined as a set of points that are all the same distance (r) from a given point in a three-dimensional space. The formula for calculating the volume of a sphere is:
Where r represents radius, and the Greek letter π ("pi")...Read more
Area of a parallelogram
A parallelogram is a quadrilateral (4-sided) shape with two pairs of parallel sides. The opposite sides of a parallelogram are the same length, and the opposite angles have the same measure. In Euclidean geometry, the area enclosed by a parallelogram is defined by this formula: A=bh,...Read more
Area of a trapezoid
In geometry, the area enclosed by a trapezoid is defined by this formula:
...Read more