A square root is a number that can be multiplied by itself to give another number. Excel is a multipurpose tool for calculating mathematical calculations. Several ways can be used to calculate the square root of a given number in Excel. This post will discuss formulas and workarounds that can be used to calculate Square Root in Excel.
Using the SQRT function
a) Using the Formula tab
Steps to follow while using this method:
1. Open the Excel application.
2. Click on the cell to which you want to add the formula.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the Insert Function button to open the Insert Function dialogue box.
5. In the Search for a Function section, type SQRT and press the Go button.
6. Select the SQRT option in the Select a Function section and then hit the Ok button.
7. A Function Argument dialogue box will open. In the dialogue box, enter the number you want to find its square root in the Number Section.
Alternatively, you can choose a cell with the number you want to find its square root.
b) Using the formula bar
Steps to follow while using this method:
1. Open the Excel application.
2. Click on the cell to which you want to add the function.
3. Locate the Formula bar on the screen, and click on it.
4. Type the Equal sign (=) in the formula bar.
5. Then, type SQRT next to the equal sign in the formula bar. That is, =SQRT
6. Type the opening bracket; add the number you want to find the square root, and then type the closing bracket. That is, =SQRT(16).
7. Finally, hit the Enter Key on your keyboard.
c) Using cell reference
Steps to follow:
1. Open the Excel application.
2. Click on an Empty cell that will contain the square root.
3. On the selected cell, type the Equal sign (=) followed by the SQRT function.
4. Next, type the cell reference of the cell that contains the number you want to find its square root. That is, =SQRT (A1).
5. Finally, hit the Enter Key on your keyboard.
Using the Power Function
a) Using the Insert Function Tool
Steps to follow while using this method:
1. Open the Excel application.
2. Click on the cell that you want to add the formula.
3. Click on the Formulas tab on the screen, and then locate the Function Library section.
4. Click the Insert Function button to open the Insert Function dialogue box.
5. In the Search for a Function section, type Power ad press the Go button.
6. In the Select a Function section, select the Power option and then hit the Ok button.
7. In the Function Argument dialogue box, enter the number you want to find its square root in the Number Section.
8. In the Power section, enter 0.5, and then hit the Ok button.
b) Using the Formula bar
Steps:
1. Open the Excel application.
2. Click on the cell that you want to add the function.
3. Locate the Formula bar on the screen, and click on it.
4. Type the Equal sign (=) in the formula bar.
5. Then, type Power next to the equal sign in the formula bar.
6. Enter the number and power (They should be comma-separated). That is, =Power (16, 0.5).
