Quickly calculate the length of the rectangle diagonal

 Known length and width of the rectangle, are now required to calculate the diagonal length, with Excel you can quickly calculate the answers. How does it work?

 Let the rectangle length X, width Y, the diagonal length of Z, then, can be seen from this formula, requiring the Z, there are two steps. First, calculate the square value of X and Y value of the square, and add them up; Second, the first step to calculate the value of evolution, the resulting figure is the Z. Obviously, we want to use to Excel, the two functions, one is to calculate the square of a number, that number to a power; Second, calculate the square root. Here are the two mathematical functions are used.

 ■ Back to the given number of power: POWER

 POWER function computing power of numbers, it's syntax is: POWER (number, power)

 Number is the base which can be any real number.

 Power is the exponent, the power base power by the index.

 For example, we asked five of the secondary side, which is square, you can enter the cell: "= POWER (5,2)", you can get the answer 25.

 ■ Returns a given number is the square root: SQRT

 Its syntax is: SQRT (number)

 Number one is to calculate the square root of the number.

 For example, we required a square root of 16, you can enter the cell: "= SQRT (16)", you can get the answer 4.

 Know the usage of these two functions, we can easily come to Z's value.

 Find the X and Y, respectively, before the square, and then add them up, then the value derived by adding the square root, we can deduce the answer.

 If you still feel this way is slow, there is a better way. Here's a function: SUMSQ

 ■ Returns the sum of the squares: SUMSQ

 Its syntax is: SUMSQ (number1, number2, ...)。 number1, number2, etc. within 30 the number of them can be calculated with this function and the square, so that, just enter the X and Y values to their sum of squares can be calculated, and then calculated as SQRT function Finally, Z values can be calculated.