Microsoft Office Tutorials and References
In Depth Information
Revisiting Function Structure
Table 4–2. Function Types
Kind of Function
Contains the same function list you’ll see when you click the AutoSum
button on the Home tab.
Lists the last ten functions you’ve used.
Lets you perform many kinds of financial calculations, including interest
projections and investment yields.
and other functions that help you decide between
). For example, the statement
means that if either score in
cell A2 or A3 equals 65 or higher, then the student passes.
Contains functions that let you learn information about cells containing
text. For example,
will yield an answer of AB in a cell
containing the text XYZ-AB, by identifying the two rightmost characters
in the cell.
Date & Time
Lets you work with chronological data. For example, the function
which has nothing between its parentheses, will tell you the precise time
when you enter new data in the spreadsheet, and will update whenever
you enter new data.
Lookup & Reference
Lets you find particular data in a range, among other tasks. The
function, for example, can look up a person’s income in a table and tell
her how much tax she owes.
Math & Trig
Contains many mathematical and trigonometric functions, including
Contains a host of additional functions, including ones that perform
statistical and engineering tasks.
By clicking the arrow at the bottom of
each button, you’ll be able to view a list of
all the functions assigned to that group;
hovering your arrow over any name yields
a brief description of what that function
does. Figure 4–17 shows what you’ll see if
you rest your mouse over IF, stored in the
Figure 4–17. Excel describes the function when you
scroll over it.