Funções Matemáticas

Vamos considerar algumas funções matemáticas. Na segunda seção, já utilizamos a função SUM (SOMA) e criamos uma fórmula personalizada para calcular a porcentagem.

Task:

Calculate the area and circumference of circle given its radii.

• Prepare Your Excel Sheet:
  • Create a table with the first column labeled "Radius";
  • Add two more columns labeled "Area" and "Circumference";
• Enter Radii equal to 5;
• In the "Area" column, use the formula: =PI() * POWER(A2, 2);
• In the "Circumference" column, use the formula: = PI() * A2 * 2;
• Additionally, you can round the results using the =ROUND() function.

Note

In different versions of Excel or Sheets, commas (,) are used to separate function arguments, while in other versions, semicolons (;) are expected. You can verify this in the syntax hints that appear when entering a formula.