Computer Digital Expo
internet.com
You are in the: Small Business Channel arrow

Internet.com
Enter a keyword... ...or choose a category.
 
 

menu
   Home
   Term of the Day
   New Terms
   New Links
   Quick Reference
   Did You Know?
   Search Tool
   Tech Support
   Webopedia Jobs
   About Us
   Link to Us
   Advertising
  

talk to us
   Submit a URL
   Suggest a Term
   Report an Error

internet.com
Internet News
Internet Investing
IT
Windows Technology
Linux/Open Source
Developer
Interactive Marketing
xSP Resources
Small Business
Wireless Internet
Downloads
Internet Resources
Internet Lists
International
EarthWeb
Career Resources

Search internet.com
Advertise
Corporate Info
Newsletters
E-mail Offers
commerce
  Be a Commerce Partner
 
 
 
 
 
 
 
 
 
 

spreadsheet
Last modified: Friday, May 16, 2003 

A table of values arranged in rows and columns. Each value can have a predefined relationship to the other values. If you change one value, therefore, you may need to change other values as well.

Spreadsheet applications (sometimes referred to simply as spreadsheets) are computer programs that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in a cell. You can define what type of data is in each cell and how different cells depend on one another. The relationships between cells are called formulas, and the names of the cells are called labels.

Once you have defined the cells and the formulas for linking them together, you can enter your data. You can then modify selected values to see how all the other values change accordingly. This enables you to study various what-if scenarios.

A simple example of a useful spreadsheet application is one that calculates mortgage payments for a house. You would define five cells:

  • 1. total cost of the house
  • 2. down payment
  • 3. mortgage rate
  • 4. mortgage term
  • 5. monthly payment
  • Once you had defined how these cells depend on one another, you could enter numbers and play with various possibilities. For example, keeping all the other values the same, you could see how different mortgage rates would affect your monthly payments.

    There are a number of spreadsheet applications on the market, Lotus 1-2-3 and Excel being among the most famous. The more powerful spreadsheet applications support graphics features that enable you to produce charts and graphs from the data.

    Most spreadsheet applications are multidimensional, meaning that you can link one spreadsheet to another. A three-dimensional spreadsheet, for example, is like a stack of spreadsheets all connected by formulas. A change made in one spreadsheet automatically affects other spreadsheets.

    E-mail this definition to a colleague

    Sponsored listings

    Gateway: Office Suite Software Sells office suite software including Microsoft, Novell, Corel, and ThinkFree office software.

    BizRate.com: Office Suite Software Comparison Shopping BizRate.com offers price comparisons, consumer reviews, product features, and store ratings from over 2,000 stores across the web.

    eBay: Accounting Online marketplace for buying and selling accounting spreadsheets and calculators.



    For internet.com pages about spreadsheet . Also check out the following links!

    Related Links

    Spreadsheet user group page
    The Spreadsheet user group site offers links to information on Excel and 1-2-3 magazines, support, resources, and seminars.

    Yahoo!'s spreadsheet companies page
    Yahoo!'s directory of spreadsheet companies.

    related categories

    Spreadsheets

    related terms

    absolute cell reference

    Borland International

    cell

    formula

    label

    Lotus 1-2-3

    three-dimensional spreadsheet

    VisiCalc


    webopedia
    Give Us Your
    Feedback



    Shopping
    SPREADSHEET Products
    Compare Products,Prices and Stores

    Shop by Category:
    Business and Productivity
     118 Model Matches

    Programming Tools
     29 Model Matches


    Copyright 2003 Jupitermedia Corporation All Rights Reserved.
    Legal Notices,  Licensing, Reprints, & Permissions,  Privacy Policy.
    http://www.internet.com/