MS Excel : Find SQUARE PRODUCTS AND ROOTS

MS Excel : Find SQUARE PRODUCTS AND ROOTS


Many Excel users are familiar with the basics
Available operations by clicking on the Autosuma button:
addition, subtraction, minimum, maximum and
tell. Less are familiar with two other basics
operations available by using a math
function. Using the PRODUCT function, you can
multiply two or more numbers, and using the SQRT
function, you can find the square root of a number.

Excel can calculate the square roots of positive
only numbers. If a negative number is the argument,
As in SQRT (–1), Excel returns # NUM in the cell.
You can calculate a PRODUCT or SQRT by entering the
values ​​to be used in the function in the worksheet.
If you do not want the values ​​to appear in the
worksheet, start by clicking on the cell where
the result is to appear and press an equal sign (=),
writing the name of the function - PRODUCT or SQRT - and
parentheses Click the Insert Function (fx) button to
Enter your values ​​for the formula.

MS Excel : Find SQUARE PRODUCTS AND ROOTS


CALCULATE A PRODUCT
1 Enter the values ​​you want
multiply.
2 Click on the cell in which
He wants the result to appear.
3 Type = product (in the cell.
Note: writing the function directly
in a cell or in the formula bar
preceded by an equal sign is a
alternative to choose it from the
Function Assistant
4 Click the Insert Function button.
l The Function Arguments dialog box
the picture appears

MS Excel : Find SQUARE PRODUCTS AND ROOTS


5 Click on the cell address of the first
value you want to multiply or
Enter the address of the cell.
Optionally, you can enter a value
directly in the Number1 field.
6 Click on the cell address of the
second value you want
multiply or type the address of the cell.
Optionally, you can write the
value directly at Number2
countryside.
l The Function Arguments dialog box
The table shows the provisional response.
7 Click OK.
l The product appears in the cell
You clicked on Step 2.

MS Excel : Find SQUARE PRODUCTS AND ROOTS


CALCULATE A SQUARE ROOT
1 Click on the cell in
which one do you want
result to appear.
2 Type = SQRT (in the
formula bar or in the
cell in which you want
The result to appear.
As you start writing,
Autocomplete function
The list appears.
Double click on an option.
to select it
3 Click on the Insert function
button.

MS Excel : Find SQUARE PRODUCTS AND ROOTS


The Function Arguments dialog box
appears.
4 Enter the value for which you want
square root.
Optionally, you can click on a cell
that contains the value
l The Function Arguments dialog box
Show the provisional response.
5 Click OK.
l The square root appears in the cell.

Apply it!

Find the power of any number, such as 3 to 9
power, use the power function.

Did you know

Each argument in PRODUCT can have more than
a value, for example, 2, 3 and 4. These values
It can be represented as a matrix, a series of numbers
locked in braces: {2,3,4}. Every value in the
The matrix is ​​multiplied, so the product of {2,3,4} is 24.
The matrices can be multiplied with each other. Each value
In the matrix it has to be a number.