answersLogoWhite

0


Best Answer

Area of circle = PI * R2

  1. In A1 enter radius of circle (e.g. 4).
  2. In B1 enter this formula: =PI()*A1^2
  3. Observe in B1 the number as the area of a circle with radius of 4.
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you work out the area of a circle on excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How can you draw a perfect circle in Excel?

You cannot. Excel can only work in approximations. You would ned an infinite number of cells to generate a perfect circle.


What is the main work area in excel?

The worksheet.


How do you work out the area of a circle with only the diameter?

By dividing the diameter by 2 will give the circle's radius. Area of any circle = pi*radius squared.


How do you work out the area of a cycle?

Area of any circle = pi*radius squared


What is the radius and the area of a circle?

The radius of a circle is the distance from the center to any point on the circle. The area is the space within the circle. The formula to find the area is πr2. r stands for the radius of the circle. If you want to find the radius, you can work backwards from the area or the circumference, which is the perimeter of the circle. The formula for circumference is 2πr.


Why does the formula for area of a circle work?

It says so in the formula


How do you work out the area of circle?

Pi times the square of the radius.


How do you work out the area of a quarter of a circle?

It is: (pi*radius2)/4


Does the area of a sector depend pi?

The area sector of a circle needs pi to work it out.


Is a sector area the percentage of the circle's area?

Yes. That is often how pie charts work.


How do you measure the area of a circle and why does it work?

The area of a circle is equal to that of a triangle whose base has the length of the circle's circumference (distance around the circle) and whose height equals the circle's radius which comes to Pi multiplied by the radius squared. Area of Triangle 1/2 *base*height


How did the Romans work out the area of a circle?

The area of a circle is the number of square units inside that circle, if each square in the circle to the left has an area of 1cm2, you could count the total number of squares to get the area of this circle. However, it is easier to use one the following formulas; A=.r²or A=pi times r times r, where A is the area and r is the radius.