The basic operations such as add, subtract, divide or multiply are the most used in spreadsheets . However, Microsoft Excel has multiple tools and utilities that allow us to perform a large number of equations and functions .
One of them is raising numbers exponentially . This operation is very useful in statistical and probability analysis tasks . However, it can be a bit tricky to find if you haven’t read this post.
If you want to know what is the easiest way to use the power functions in Microsoft Excel, we recommend this post.
Steps to square a quantity in a Microsoft Excel data table
There are several methods for squaring a given number. In all cases, this is a simple operation and shouldn’t be a problem for you.
Let’s see how:
- Access Microsoft Excel from the Office folder or through a shortcut.
- In an empty cell, put the formula “= N ^ 2” Where “N” is the number you want to square .
- Press “Enter” and you will get the result .
In case you need to do several operations, do the following:
- Put in the first column, all the values of “N” that you are going to square.
- In the second, enter the formula “= A2 ^ 2” and press “Enter . “
- Select box B2 again and drag it from the lower right corner until you reach the row that corresponds to the last number entered in the first column .
- Otherwise, copy B1 with “Ctrl + C” and paste it with “Ctrl + V” in the cells that follow in the column, ie B3, B4, etc .
If you can’t find the “^” symbol that represents power on your keyboard, you can use the combination “Alt + 94”.
Learn step by step to exponentially raise any quantity in a table in Excel
As with the square, there are different ways to cube a certain number.
These can also be applied to any exponent, as we will see below:
To the bucket
Once in Excel, create a new document or enter an old one.
- In an empty cell, put the formula “= N ^ 3” Where “N” is the number you want to square .
- Press “Enter” and the result will appear in the same box .
If you are going to do several operations, we recommend the following:
- In the first column (in the example it is A ) enter all the values that you are going to cube.
- In the next column (in the example it is B ). Put the formula “= A1 ^ 3” and hit “Enter . “
- Select cell B1 again and drag it from the lower right corner to the row corresponding to the last number entered in the first column (as shown in the image) .
- Another way is to copy the cell B1 with “Ctrl + C” and paste with “Ctrl + V” successive times in the boxes that follow in the column, ie B2, B3, etc .
To any other exponent
Taking as a base the function that we used before in square “= N ^ 2” and in cube “= N ^ 3”, follow these steps:
- Replace “N” with the number you want to raise and “2” or “3” with the exponent that you are going to give it. For example, if you wanted to obtain the result of 5 raised to the fourth power, you would place in an empty cell “= 5 ^ 4” .
- If you need to do several of these operations with different numbers in both components of the equation, enter the values of “N” in one column and the exponents in the next.
- Then put the formula “= A1 ^ B1” (in the case of the example).
- Press the “Enter” key and drag this cell to the end of the list, always staying in the same column .
You can see in the image that both “N” and the exponent must always be numbers .