Microsoft Office Tutorials and References

In Depth Information

The following table describes some of the most useful functions in the list.

Function

Description

Finds the sum of the numbers in the specified cells

SUM

Finds the average of the numbers in the specified cells

AVERAGE

Finds the number of entries in the specified cells

COUNT

Finds the largest value in the specified cells

MAX

Finds the smallest value in the specified cells

MIN

Two other functions you might use are the
NOW
and
PMT
functions. The
NOW

function displays the time Excel updated the workbookâ€™s formulas, so the value will change

every time the workbook recalculates. The proper form for this function is
=NOW()
.

To update the value to the current date and time, just press the F9 key or display the

Formulas tab and then, in the Calculation group, click the Calculate Now button. You

could, for example, use the
NOW
function to calculate the elapsed time from when

you started a process to the present time.