Using Functions

When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.

Excel's different functions

There are many functions in Excel. For our purposes in Excel 2000, we will discuss some common functions.

Statistical functions:

SUM: Summation adds a range of cells together.
AVERAGE: Average calculates the average of a range of cells.
COUNT: This counts the number of chosen data in a range of cells.
MAX: This identifies the largest number in a range of cells.
MIN: This identifies the smallest number in a range of cells.

Financial functions:

Interest rates
Loan payments
Depreciation amounts

Date and time functions:

Day of week
Year
Time
Date

Important pointYou don't have to memorize the functions, but you should have an idea of what they will do for you.