Symbols used in Mathematics Symbols used in Excel Function used in Excel 4^(1/2) SQRT(4)

Excel has a pre-made square root function. Just as with a pocket calculator the function is used so frequently it is given its own shortcut. This function is written SQRT(number) where a number or to say it mathematically an argument must be put inside the parentheses. The function will accept a cell coordinate or a pure number as an argument. For example SQRT(B3) is acceptable even is there is nothing in cell B3 yet. You will know when you have written (called) the function incorrectly, as this will appear. Excel has a built in system that checks for errors in your  formula. If Excel spots a mistake it will notify you of an general error. This usually occurs because you have not written the argument correctly or did not complete the parentheses.

How to use the SQRT() function: Click on the relevant cell Type " =SQRT( ". Enter the numerical argument. Type " ) " then press the "Enter" key

How to use the SQRT() function: Click on the relevant cell Type " =SQRT( ". Enter the coordinate of the data cell. Type " ) " then press the "Enter" key Note: The Ripple effect and auto update.

How to use the SQRT() function: Click on the relevant cell Type " =SQRT( ". Enter the coordinate of the data cell. Type " ) " then press the "Enter" key Drag the fill handle to fill the column. Note: The intelligent autofill.