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
 
Search JabSto ::




Custom Search