A function is a formula that is already created by Excel. It can be used to perform a calculation on the data in your worksheet.
Here's a list of the common functions built into Excel. There is also a description on how to use them.
What does it do? Adds a list of numbers.
How do you use it? =SUM(A1:A4)
This will add cells A1, A2, A3, and A4 and send the results to where you place the formula.
What does it do? Calculates the average of a list of numbers.
How do you use it? =AVERAGE(A1:A4)
This will add A1, A2, A3, and A4 and divide it by four. If you have more or less cells than what is listed, it will divide the sum of the cells by the number of cells.
What does it do? Find the largest value in a list of numbers.
How do you use it? =MAX(A1:A4)
This function will print the maximum value of the cells in the formula.
What does it do? Calculates the number of values in a list.
How do you use it? =COUNT(A1:A4)
This function will calculate the number of values in the cells A1, A2, A3, and A4.
What does it do? Find the smallest value in a list of numbers.
How do you use it? =MIN(A1:A4)
This function will print the smallest number of cells A1, A2, A3, and A4.
What does it do? Rounds a value from a cell to a specific number of digits.
How do you use it? =ROUND(A1,2)
This function will take the value of A1, round it to 2 decimal places, and print the modified value into the cell where you have put this function.
Note: All the cell names and other data in the functions can be changed. We have shown them as they are just to give an example.
Books on Microsoft Excel
Choosing a Cell Phone and Rate Plan - General Articles
Stopping Unwanted E-mail - General Articles
Learn about Cookies - Microsoft Windows
HotSync Timeout Errors - Palm OS
Also from Computertim Technologies
Thoughts on Internet Advertising - an interactive opinion essay by Tim Rooney.
Post your opinions on technology and get free computer help in the forums.
Tired of AOL? Try Juno for half the price of AOL.
Shop for the best deals online at our shopping site.