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.