Summary  
This chapter covers using built-in mathematical functions and function nesting to perform calculations and apply rounding.  

General domain of usage  
Geometric computations

Let's consider some mathematical functions. In the second section, we already used the **SUM** function and made a custom formula for calculating percentage.

### 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.

What is the area of the circle with a radius equal to 5, rounded to two decimal places?

What is the circumference of the circle with a radius equal to 5, rounded to two decimal places?

Unlock the power of Excel for data analysis! In this course, you will acquire the essential skills and knowledge needed to harness Excel's full potential as a data analysis tool. From mastering formulas and functions to visualizing data with charts and graphs, you'll gain the expertise to confidently navigate Excel's features. Whether you're a beginner or looking to enhance your existing Excel skills, this course will equip you with the tools to excel in data analysis. Join us and take your data manipulation and interpretation abilities to the next level.

Begin your Excel journey by learning essential basics: navigating the interface, entering data, and understanding Excel's basics.

Master the art of formulas in Excel, from simple calculations to advanced data manipulation techniques for efficient analysis.

Explore Excel's powerful functions! Learn Logical, Mathematical, and Statistical functions to boost your data analysis skills.

Learn to transform data into insightful visuals. Explore chart creation and formatting to effectively communicate your findings and enhance data-driven decision-making.

Efficiently manage and organize data within Excel. Discover techniques for data sorting, filtering, and handling large datasets with ease.

Dive deep into Excel's advanced capabilities. Explore topics such as pivot tables, macros, and data analysis tools to elevate your Excel proficiency.

Mathematical Functions

Task:

1. What is the area of the circle with a radius equal to 5, rounded to two decimal places?

2. What is the circumference of the circle with a radius equal to 5, rounded to two decimal places?