Explanation
In geometry, the area enclosed by a circle with radius (r) is defined by the following formula: πr 2
The Greek letter π (“pi”) represents the ratio of the circumference of a circle to its diameter. In Excel, π is represented in a formula with the PI function , which returns the number 3.14159265358979, accurate to 15 digits:
=PI() // returns 3.14159265358979
To square a number in Excel, you can use the exponentiation operator (^):
=A1^2
Or, you can use the POWER function :
=POWER(A1,2)
Rewriting the formula =πr2 as an Excel formula to for the example, we get:
=PI()*B5^2
Or:
=PI()*POWER(B5,2)
The result is the same for both formulas. Following Excel’s order of operations , exponentiation will occur before multiplication.
Explanation
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 , where b stands for base and h stands for height.
In Excel, the same formula can be represented like this:
=b*h
So, for example, to calculate the area of a parallelogram where b is 5, and h is 4, you can use a formula like this:
=5*4 // returns 20
In the example shown, the goal is to calculate the area for eleven parallelograms using the base value in column B and the height value in column C. The formula in D5 is
=B5*C5
Because both cells are entered as relative references , as the formula is copied down the table, it calculates a different area at each new row.
