![use excel use excel](https://cdn.free-power-point-templates.com/articles/wp-content/uploads/2019/12/if-function-in-excel-example-1.png)
Right-click on the cell and select the Formal cells option.Select the exponent number only (as shown below). Now enter both Base number and Exponent in the cell next to next without any space.This can be done either by selecting the cells and choosing the Text option from the dropdown list in the “Home” tab under the “Number” section or right click on the selected cells and select the “Format Cells” option to select the Text option under “Number” tab. The formatting of the cell depends upon the nature of the data present. Change the format of the selected cells Change The Format Of The Selected Cells Formatting cells is an important technique to master because it makes any data presentable, crisp, and in the user's preferred format. Select the cells where you want to input the exponent’s value.To write or express the exponents, we need to use text-based exponents. It is a shorthand used for the power function. Using the “Caret” symbol, the power function can be applied using the Base number and exponent. The first row in the above table is finding the square root, the second row is for cube root, and the third row is the nth root of the number. Moreover, this function accepts a single argument. To use this function, type the term =SQRT and hit the tab key, which will bring up the SQRT function. read more for square root in excel Square Root In Excel The Square Root function is an arithmetic function built into Excel that is used to determine the square root of a given number. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Given below is the example of using the excel cell reference Excel Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties. In this table, the first row has the base number like 49, which is the square root of 7 (7 x 7) and 125 is the cube root of 5 (5 x5 x5), and 244 is the 6 th root of 2.5 (2.5 x 2.5 x 2.5 x 2.5 x 2.5 x 2.5). The exponents used to find the square root is (1/2), the cube root is (1/3), and the nth root is (1/n). This power function can be used to find out the Square root, Cube root, or nth root of the number. Here in the first row, 5 is multiplied twice, i.e., 5 x 5. In the formula, the base number and the exponents can be used directly instead of the cell reference. The first row has the base number of 6 and exponent as 3, which is 6 圆 x 6, and the result is 216, which can be derived using a power function in excel.