While using MS Excel, you may require to compute square root of of a large data. Microsoft Excel has a plethora of functions, which can help you to compute mathematical operations in a single click. For example, you can calculate sum of elements of a row of different columns, or square, multiplication, division, square root, cube root, any power, etc.
In this article, I will show you some simple tips which will help beginner Excel users to compute square root easily. In case you don’t know what square root is. Here is an example. Square of a number means the number multiplied by itself. So, square of 5 is 25. This means, square root of 25 is 5. Square of 7 is 49. This means square root of 49 is 7 and so on.
Steps To Calculate Square Root In Microsoft Excel
Method 1: Using Power Formula
As discussed before, that you can compute power of any number using Excel functions. To find square root, simply replace the power by 1/2 or 0.5.
Example =POWER(36,1/2) and hit Enter
You can also insert the cell value instead number
Method 2: Using SQRT function
=SQRT(number or cell value)
That’s very simple.
Method 3: Using Carat (^) operator
The Carat operator in MS Excel enables you to raise any number’s base value using power or exponent. It is similar as h=the POWER function.
=Cell value or number ^(1/2)
That’s all! Hope the article helped you.