Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

CONVERT(number,from_unit,to_unit) [Category: Engineering]*

Converts a number from one measurement system to another. For example,

CONVERT can translate a table of distances in miles to a table of distances in

kilometers. Guru Tip: Check out the help topic for this function to get the exact

abbreviations for the various measurement units. The function is incredibly

versatile, offering conversions of weight, distance, time, pressure, force, energy,

power, magnetism, temperature, and liquid measure. Some of the more common

abbreviations are shown below.

CORREL(array1,array2) [Category: Statistical]]

Returns the correlation coefﬁ cient of the array1 and array2 cell ranges. Use

the correlation coefﬁ cient to determine the relationship between two properties.

For example, you can examine the relationship between a location’s average

temperature and the use of air conditioners.

COS(number) [Category: Math]

Returns the cosine of the given angle. Guru Tip: Although you probably learned

about the cosine function in a high school geometry class where the cosine of

360 degrees is 1, the cosine in Excel does not work with degrees, it works with

radians. There are 2 x Pi radians in a circle. To convert the degrees shown in

column A to radians, use the RADIANS function.