Microsoft Office Tutorials and References
In Depth Information
Revisiting Function Structure
Table 4–2. Function Types
Group Name
Kind of Function
AutoSum
Contains the same function list you’ll see when you click the AutoSum
button on the Home tab.
Recently Used
Lists the last ten functions you’ve used.
Financial
Lets you perform many kinds of financial calculations, including interest
projections and investment yields.
Logical
IF
Includes
and other functions that help you decide between
alternatives (e.g.,
AND
OR
). For example, the statement
=IF(OR(A2>=65,A3>=65),"Pass","Fail")
and
means that if either score in
cell A2 or A3 equals 65 or higher, then the student passes.
Text
Contains functions that let you learn information about cells containing
text. For example,
=RIGHT(D12,2)
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
NOW()
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
VLOOKUP
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
SUM
Contains many mathematical and trigonometric functions, including
.
More Functions
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
Logical group.
Figure 4–17. Excel describes the function when you
scroll over it.

Search JabSto ::

Custom Search