Squaring in Excel  Step by Step Guide ▷ 2020

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:

Steps to square a quantity in a Microsoft Excel data table

  • 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.

Then:

Learn step by step to exponentially cube any quantity in a table in Excel

  • 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:

Learn step by step how to exponentially increase any quantity in a table in Excel to the cube to any other exponent

  • 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! 😉

You may be interested:

Rate this post

Leave a Comment