Square Formula in Excel


Home >> How to Use Excel Tutorial >> Excel Calculations >> Square Formula in Excel



In this tutorial, you will learn how to write the square formula in excel. Square excel formula is one of the calculation variables often needed in our data processing. Generally, there are two ways for utilizing it, manually and by using the POWER formula.

The explanation about them will be explained in more detail in the next parts of this tutorial.


Why do We Need to Learn About Excel Formula to Square a Number?


In mathematic calculation, one of the popular calculation types is the power of two or often called square. It is one of the important calculations to learn when we want to process numeric data. When we use a spreadsheet file for data processing, it is important to know how to calculate that in a spreadsheet. If we don’t understand, then our numeric data processing can be not optimal and gives error results.

As one example of these calculation needs at work, imagine if we are giving scores to each salesperson in our company. In the scoring process, there might be a formula to determine the final score. In this formula, one or more calculation variables might be needed to be squared.

If the scoring process is done in a spreadsheet file, then we need to write the formula of square in excel. If there are hundreds of salespeople need to be assessed, then the way to do it automatically is important to know.

For that, you need to learn how to use the square formula in excel. The understanding will help you optimizing the processing of the numbers in your spreadsheet. If you often deal with numeric data, then it becomes more crucial for you to learn this calculation process.


What is Square Formula in Excel?


The square formula in excel is a formula with the usage objective to multiply a number with itself once. It is sometimes needed in the numeric data processing on a spreadsheet file to get the processing results we need.


How to Use Excel Formula to Square a Number?


The following will explain the methods to write an excel formula for squaring a number. There are three methods for the calculation process. Those three are by utilizing the signs of an up pointed arrow (^), star (*), and using the POWER function.

All of these methods produce the same results. Because of that, it is up to you which method you want to use later in doing your calculation.

How to use the three methods to write square formula in excel will be explained step-by-step below.


Method 1: Manual (Using ^)

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Square Formula in Excel - Screenshot of Step 1-1

  2. Input digit or cell coordinate where you put the digit to be squared in after =. Type up pointed arrow sign ( ^ ) after that

    Square Formula in Excel - Screenshot of Step 1-2

  3. Type 2

    Square Formula in Excel - Screenshot of Step 1-3

  4. Press Enter
  5. The process is done!

    Square Formula in Excel - Screenshot of Step 1-5



Method 2: Manual (Using *)

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Square Formula in Excel - Screenshot of Step 2-1

  2. Input digit or cell coordinate where you put the digit to be squared in after =. Type up pointed arrow sign ( ^ ) after that

    Square Formula in Excel - Screenshot of Step 2-2

  3. Input the digit or cell coordinate again

    Square Formula in Excel - Screenshot of Step 2-3

  4. Press Enter
  5. The process is done!

    Square Formula in Excel - Screenshot of Step 2-5



Method 3: POWER

  1. Type equal sign ( = ) in the cell where you want to put the result in

    Square Formula in Excel - Screenshot of Step 3-1

  2. Type POWER (can be with large and small letters) and open bracket sign after =

    Square Formula in Excel - Screenshot of Step 3-2

  3. Input digit or cell coordinate where the digit which you want to be squared is after the open bracket sign. Then type a comma sign ( , )

    Square Formula in Excel - Screenshot of Step 3-3

  4. Type 2

    Square Formula in Excel - Screenshot of Step 3-4

  5. Type close bracket sign

    Square Formula in Excel - Screenshot of Step 3-5

  6. Press Enter
  7. The process is done!

    Square Formula in Excel - Screenshot of Step 3-7



Exercise


After understanding how to write the square formula in excel, now let’s do an exercise. This is so you can deepen your understanding on the methods.

Download the following exercise for using the square formula in excel and answer all the questions. Download the answer key file if you have finished the exercise and want to check your answers. Or probably when you are confused about how to answer the questions.

Link to the exercise file:
Download here

Questions

  1. What is the final score of each person? Use method 1 from the tutorial to find the answer!
  2. What is the final score of each person? Use method 2 from the tutorial to find the answer!
  3. What is the final score of each person? Use method 3 from the tutorial to find the answer!

Link to the answer key file:
Download here


Additional Note


To use the power calculation with other factors besides 2, you can learn it by visiting this Compute Expert tutorial.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert