Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
Connects with an external data source, and runs a query from a worksheet.
SQL.REQUEST then returns the result as an array without the need for macro
programming. If this function is not already available, install the Microsoft Excel
ODBC add-in (XLODBC.XLA).
SQRT(number) [Category: Math]
Returns a positive square root. Guru Tip: Sure – it is nice of Microsoft to provide
this function, but what if you need a cube root or a fi fth root? To fi nd a square
root, raise a number to the (1/2) power. =25^(1/2). To fi nd a cube root, raise the
number to the (1/3) power: =125^(1/3).
SQRTPI(number) [Category: Math]*
Returns the square root of (number * pi). Guru Tip: This obscure function is used
to convert round objects into equivalent sized square object. If you have a round
pizza with a radius of 8", use =SQRTPI(8^2) to see that the equivalent sized
square pizza is 14.18".
STANDARDIZE(x,mean,standard_dev) [Category: Statistical]]
Returns a normalized value from a distribution characterized by mean and
standard_dev.
STDEV(number1,number2,...) [Category: Statistical]]
Estimates standard deviation based on a sample. The standard deviation is
a measure of how widely values are dispersed from the average value (the
mean).
STDEVA(value1,value2,...) [Category: Statistical]]
Estimates standard deviation based on a sample. The standard deviation is
a measure of how widely values are dispersed from the average value (the
mean). Text and logical values such as TRUE and FALSE are included in the
calculation.
STDEVP(number1,number2,...) [Category: Statistical]]
Calculates standard deviation based on the entire population given as arguments.
The standard deviation is a measure of how widely values are dispersed from
the average value (the mean).
 
Search JabSto ::




Custom Search