O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4

Using Functions

Publisher Summary

Microsoft Excel 2007 provides over 300 worksheet functions, which are divided into 12 groups: Add-in and Automation, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup and Reference, Math and Trigonometry, Statistical, and Text. Functions are always used as part of a formula as in =SIN(Al) or =8+LOG(Bl, 2). When a cell contains a formula, the formula bar displays that formula, but the cell generally displays the value produced by the formula. The phrase “the value returned by the formula is” often used for this quantity. The terms SIN and LOG are the names of the functions and the quantities Al, Bl, and 2 are called arguments. Arguments are contained within parentheses, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required