Power Function

Microsoft excel has provided power function. You can calculate the power of a number. For example you can see the following examples:

1. create a table like the following
We will calculate the power of the existing numbers in column A, then calculate the power (power 2 in column B) and power 4 in column C

2. Below we will try to use the power formula;
General formula:

= POWER (number, power)

a. the input formula B4 cells
= POWER (A4, 2)
b. In the cells enter the formula C 4
= POWER (A4, 4)

You also can use another formula, such as:
General formula

= number ^ power

a. In cell B11 type the formula
= A11 ^ 2
b.a In cell C11 type formula
= A11 ^ 4

You can see the result as below

Function square root (square)

Microsoft excel provides a function to calculate (calculate) the root of a number, you can calculate the square root, cube root, and so on.

Here is a simple example:

1. Create a table like the following
(table with a light blue background, not fill because the content will be filled a formula)

2. In cell B4 content of the formula:

= SQRT (A4)

other than the above formula you can use the formula:
a. B10 cells, you can calculate the square root of the number of cells with the formula A10:

= A10 ^ 0.5

b. or in cell C 10, you can calculate the cube root of the number of cells with the formula A10:

= A10 ^ (1 / 3)

the result will look like the image below

Trigonometric functions (sin, cos, tan)

One of the mathematical functions that can be used in the microsoft excel is trigonometric functions. some of these trigonometric functions is to calculate the sine (sin), cosine (cos) or tangent (tan) of a corner.

In order to more easily able to see the example below:

1. Create a table:

2. the color table gray background will be filled with the formula
a. To calculate the sine value, in cell B4 type the formula:
= SIN ((A4) * PI () / 180)

b. To calculate the sine value, in cell C4 type formula:
= COS ((A4) * PI () / 180)

c. To calculate the sine value, in the D4 cell type formula:
= TAN ((A4) * PI () / 180)