In short, if you have a digit in an A1 cell and you want to find the square of that number, you need to use the formula like this: =A1^2. For your information, ^2 denotes the square.

If it’s a square, the ultimate “digital root” in a single digit must be any one of 1, 4, 7 and 9 — and nothing else.

Here are 3 easy ways to calculate the square root of a number in Microsoft Excel - using SQRT function, POWER function and Exponential formula.