Microsoft Office Tutorials and References
In Depth Information
Using the Insert Function Button
Formula Shortcuts
Financial functions let you track your car loan payments and calculate how
many more years until you can retire rich.
Logical functions let you create conditional logic for even smarter spreadsheets
that make calculation decisions. You already had a quick introduction to
conditional logic earlier in this chapter.
Text functions manipulate words, sentences, and other non-numeric information.
Date & Time functions perform calendar math, and can help you sort out ages,
due dates, and more.
Lookup & Reference functions perform the slightly mind-bending feat of
searching for information in other cells.
Math & Trig functions are the mathematic basics, including sums, rounding,
and all the other high-school trigonometry you’re trying to forget.
More Functions groups together some heavy-duty Excel functions intended
for specialized purposes. This category includes high-powered statistical and
engineering functions. It also includes cube functions, which are designed for
working in highly technical OLAP ( online analytical processing ) databases, and
information functions, which get “information” about the other cells in your
worksheet.
Using the Insert Function Button
Excel provides more than 300 built-in functions. In order to use a function, however,
you need to type its name exactly . That means that every time you want to employ
a function, you’ll need to refer to this topic, call on your own incredible powers of
recollection, or click over to the convenient Insert Function button.
To use the Insert Function feature, choose Formulas Function Library Insert
Function. However, formula pros skip straight to the action by clicking the fx
button that appears just to the left of the formula bar. (Or, they press the Shift+F3
shortcut key.)
No matter which approach you use, Excel displays the Insert Function dialog box
(shown in Figure 17-9), which offers three ways to search for and insert any of
Excel’s functions.
Search JabSto ::




Custom Search