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 ﬁ fth root? To ﬁ nd a square

root, raise a number to the (1/2) power. =25^(1/2). To ﬁ 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).