Microsoft Excel Worksheet Function Reference [antikvár]

Introduction This book explains the worksheet functions included in Microsoft® Excel version 5.0 and Microsoft Excel for Windows® 95. Except for a few differences, worksheet functions are identical for all operating systems supported by Microsoft Excel. Whenever information pertains to a specific operating system, such as the Apple® Macintosh®, the operating system is mentioned. What Are Worksheet Functions? Worksheet functions are the calculations buUt into Microsoft Excel for you. Each function calculates a different type of value. For example, you can use functions to calculate sums, averages, loan payments, and slopes of lines. Microsoft Excel includes hundreds of functions for financial, statistical, mathematical, trigonometric, and other types of calculations. Using these functions saves you the time and effort of knowing, calculating, and recalculating many different mathematical equations. Functions can tell you whether a condition is true or false, whether one number is greater than another, or whether two words are exactly the same. Functions also help you to sort through data by identifying and calculating minimum, maximum, average, percentile, and rankings of values. The Anatomy of a Function Each function has two parts: the name of the function and its arguments. The name of a ftinction always appears in uppercase letters and describes what the function does. For example, the AVERAGE function calculates the average of all the arguments included with the function.