Microsoft Excel has the ability to make life easier for the user if he often has to deal with various kinds of numeric operations. Calculating the square root in this program does not require any special knowledge and is quite simple.
Calculating the square root of a number
To calculate the square root of a number in the spreadsheet editor Microsoft Excel, you must first enter the root value in the first cell of the table. To do this, use the mouse cursor to select the desired cell and enter a number in its field. After completing the input, press the "Enter" button on the keyboard, which will mean the end of the operation and will allow the computer to process the entered information.
Next, select the second cell where you want to place the root value, and on the toolbar at the top of the editor window, find the fx button (when you hover the mouse cursor over it, the inscription "Insert function" will pop up). After clicking this button, in the "Function Wizard" window that appears, select the "ROOT" category in the corresponding field (if it is not displayed, find it using the search engine here).
In the next window "Function arguments" in the "number" field you need to enter the number of the first cell (containing the radical value). This can be done in two ways: manually, by entering an alphanumeric designation (for example: A1) or by clicking on the desired cell with the mouse. After that, the program will automatically calculate the root value. Now even if you change the original value, the root number will be recalculated for the new number.
Calculating the square root of a series of numbers
Let's say that you need to calculate the square root not for one or two, but for many more values. Repeating all the steps indicated in the previous paragraph for each number is no less tedious than counting on a calculator and entering data manually. And Excel would not have been such a great editor if this point had not been taken into account.
What actions should be taken in this case? Enter the numbers you want to root in the column or row. In the adjacent column (row), perform all the steps indicated in the previous paragraph of the article for the first two numbers in the list. Select the cells with the resulting values. Move the cursor over the square in the lower right corner of the selection until the cursor turns into a "+" sign. Press the left mouse button and drag the cursor to the end of the column (row). You have two parallel columns (rows): with radical expressions and their values.
