Everyone in the EXCEL form of data processing, sometimes need to ask for a number of square values, for simple single-digit squares may be able to directly calculate orally, but for some of the big data, or to use Excel's square function to deal with it, so it will be more convenient, the following demonstration of the use of Excel square function tutorials. More Excel function tutorials are in the use of tutorials, where there is a special function of the video course tutorials, for those who want to learn Excel function is a very good opportunity for partners Oh.

Excel form of the square function of the use of tutorials:

1. open excel document on the computer, enter the value of the good to open the square:

2. put the mouse to the top of the B2 cell, click on the menu bar on the side of the formula button:

3. in the formula to select the Insert Function button:

4. Will pop up a new pop-up box, select the POWER function, and then click the OK button:

5. The first parameter to choose the value to be squared, the second is the power of the second is to open the square so fill in the number 2, but also ahead of time to preview the results, and then click the OK button:

6. The first cell will be filled in on the first cell is selected, there is a cross in the lower right corner of the cell, the first cell will be filled in on the second cell. Selected under the drag and drop, you can fill the remaining cells directly on the:

After reading the above tutorials, we know that the square function of excel is a power function, the above is the use of the square function tutorial process.