GCFLearnFree.org

Every day I fall a little more in love with your site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Working with Basic Functions

Excel 2007

Single page view print copy

Working with Basic Functions

Excel's different functions

There are many different functions in Excel 2007. Some of the more common functions include:

Statistical functions:

  • SUM: Adds a range of cells together
  • AVERAGE: Calculates the average of a range of cells
  • COUNT: Counts the number of chosen data in a range of cells
  • MAX: Identifies the largest number in a range of cells
  • MIN: Identifies the smallest number in a range of cells

Financial functions:

  • Interest rates
  • Loan payments
  • Depreciation amounts

Date and time functions:

  • DATE: Converts a serial number to a day of the month
  • Day of Week
  • DAYS360: Calculates the number of days between two dates based on a 360-day year
  • TIME: Returns the serial number of a particular time
  • HOUR: Converts a serial number to an hour
  • MINUTE: Converts a serial number to a minute
  • TODAY: Returns the serial number of today's date
  • MONTH: Converts a serial number to a month
  • YEAR: Converts a serial number to a year

You don't have to memorize the functions, but you should have an idea of what each can do for you.

previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.