Lesson 17: Square Root – Square Root

Hello friends! It’s me again. Today, to continue the basic Excel series for beginners, I will introduce Square Root, also known as square root in Excel.

Exponents in Excel

Step 1: Mark the = sign to let Excel recognize it as a calculation.

Step 2: Record the calculation. (If you want to record the caret, you can use the key combination SHIFT + 6)

Square Root in Excel

Since we can’t use the regular keyboard to write square root notation, Excel has converted it to a function we can use: =SQRT()

Example using the SQRT . function

Or we can use 1/2 exponent instead of using the SQRT . function

For the square root of a negative number, the result will return an error (In mathematics, the condition for the square root to have a solution is that the number inside must be greater than or equal to zero)

We can use the ABS function to make negative values ​​according to the following example

Cube root

Since in Excel we don’t have a function for square roots, we will use exponents with 1/3 Please

Here is an example of a square root

So I just guided you about square root in Excel. How do you feel? Leave a comment to let me know what you guys think!