Computertim Technologies - free computer training, tips, and support



Home Articles Help Shop Business Education

> Articles

Microsoft Windows
Microsoft Word
Microsoft Outlook
Microsoft Excel
Microsoft PowerPoint
Microsoft FrontPage
Palm OS
General Articles




Microsoft Excel

Print article

 E-mail this page

Common Functions

Reader rating: 4 out of 10



Introduction

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.




Common Functions

Here's a list of the common functions built into Excel.  There is also a description on how to use them.

Sum

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.

Average

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.

Max

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.

Count

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.

Min

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.

Round

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.


Rate this article:

Poor   1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 - 10   Excellent


Books on Microsoft Excel




Featured articles

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.

Home  |  Articles  |  Help  |  Shop  |  Business  |  Education  |  Contact Us

Privacy Policy

Copyright 2003 Computertim Technologies.  All rights reserved.