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.