+4 votes
65 views
in Office by (242k points)
reopened
Excel: squaring a number - this is how it works

1 Answer

+5 votes
by (1.6m points)
 
Best answer

How to square a number in Excel

You don't just want to enter simple numbers in Excel, but also want to use the software to solve equations with squares? We'll show you how..

image image

In mathematics, the square of a number means the multiplication of the number by itself. This simple arithmetic operation can also be carried out in Microsoft Excel without any problems. Only one function is required for this, which is carried out by a character. In this tipps + tricks article, you can read how you can square a number even as a beginner in Excel.

How to square a number in Excel

1st step:

image

Open Microsoft Excel and click a cell on the worksheet.

2nd step:

image

Type " = " + " required number " + " ^ 2 " into the cell. The equal sign always introduces a function in Excel. In the example we choose " = 5 ^ 2 ". The square function is implemented using the caret symbol (circumflex). You will find [ ^ ] directly below the [Esc] key . Then press [ Enter ] to view the result..


...