Saturday, May 12, 2012

How to Use Squared in Excel


1. Launch Microsoft Excel, then enter the number to be squared into cell A1. Press 'Enter' to move the focus to cell A2.
2. Press the Equal sign '=' and type the word 'Power' followed by a left parenthesis '(' and then click once on cell A1 to select it as the source. Type a comma ',' and then the number '2' and a right parenthesis ')' and press 'Enter.' The cell A2 now shows the squared value of whatever is entered into cell A1, or in other words the contents of cell A1 raised to the second power. The final formula will look like this: =POWER(A1,2)
3. Change the number in cell A1 to any other number and the formula in cell A2 will automatically update to reflect the value of cell A1 raised to the second power.

Blogger news