The basic operations how to add, subtract, divide or multiply are the most used in spreadsheets. But nevertheless, Microsoft Excel has multiple tools and utilities that allow us to perform a large number of equations and functions.
One of them is the raise numbers exponentially. This operation is very useful in tasks statistics and probability analysis. But nevertheless, 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 to achieve squaring a given number. In all cases, it is a simple operation And it shouldn’t be a problem for you.
Let’s see how:
- Enter Microsoft Excel from the folder Office or through a shortcut.
- In a cell empty, place the formula “= N ^ 2” Being “N” the number you want squaring.
- Press “Enter” and you will get the Outcome.
In case you need to do several operations, do the following:
- Place in the first column, all the values from “N” that you are going to square.
- In the second, enter the formula “= A2 ^ 2” and press “Enter”.
- Select the box again B2 and drag it from the Lower right corner until reaching the row corresponding 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, that is B3, B4, etc.
If you can’t find the symbol “^” representing power on your keyboard, you can use the combination “Alt + 94”.
Learn step by step to exponentially raise any amount in a table in Excel
As with the square, there are different ways to achieve cubing a certain figure.
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 a previous one.
- In a empty cell, place the formula “= N ^ 3” Being “N” the number you want squaring.
- 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 TO) enter all values that you are going to cube.
- In the next column (in the example it is B). Place the formula “= A1 ^ 3” and press “Enter”.
- Select again the cell B1 and drag it from the lower right corner to the corresponding row to the last number entered in the first column (as shown in the picture).
- Another way is by copying the cell B1 with “Ctrl + C” and paste it with “Ctrl + V” successively in the boxes that follow in the column, that is to say 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:
- Replaces “N” by the number you want raise Y “2” or “3” by the exponent that you are going to give it. For example, if you wanted to get the result of 5 raised to the fourth power, you must place in an empty cell “= 5 ^ 4”.
- If you need do several of these operations with different numbers in both components of the equation, enter a column the values of “N” and in the next the exponents.
- Then place the formula “= A1 ^ B1” (in the case of the example).
- Press the key “Enter” and drag this cell until the end of the list, always staying the same column.
You can observe in the image, how much “N” As the exponent, must always be numbers.
If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉