Microsoft Office Tutorials and References

In Depth Information

C
ALCULATE A
S
QUARE
R
OOT

1

Click in the cell in

which you want the

result to appear.

3

2

Type
=SQRT(
in the

formula bar or in the

cell in which you want

the result to appear.

As you begin to type,

the Function

Autocomplete list appears.

Double-click an option

to select it.

2

1

4

5

3

Click the Insert Function

button.

l
The Function Arguments dialog box

appears.

4

Type the value for which you want the

square root.

Optionally, you can click in a cell

containing the value.

l
The Function Arguments dialog box

displays the interim answer.

5

Click OK.

l
The square root appears in the cell.

Apply It!

Related to
PRODUCT
and
SQRT
is
POWER
. To find

the power of any number, such as 3 to the 9th

power, use the Power function.

Did You Know?

Each argument in
PRODUCT
can have more than

one value, for example, 2, 3, and 4. These values

can be represented as an array, a series of numbers

enclosed in curly braces: {2,3,4}. Each value in the

array is multiplied, so the product of {2,3,4} is 24.

Arrays can be multiplied by each other. Each value

in the array has to be a number.

Chapter 2: Work with Formulas and Functions

47