Introduzione alla nozione di foglio elettronico Introdução à noção de planilha de cálculo Einführung in den Begriff der 
Tabellenkalkulation Introduction à la notion de tableur Hoja de cálculo

What is a Spreadsheet?

A spreadsheet (or spreadsheet program) is software that permits numerical data to be used and to perform automatic calculations on numbers contained in a table. It is also possible to automate complex calculations by using a large number of parameters and by creating tables called worksheets.

In addition, spreadsheets can also easily produce graphic representations of the data entered:

  • histograms
  • curves
  • sector charts
  • ...
Therefore, the spreadsheet is a multi-use tool that works as well for secretarial activities that involve organising large quantities of data, as at the strategic and decisional level by creating graphical representation of synthesised information.

The Main Spreadsheets

Numerous spreadsheets have been produced by the main software companies. The main spreadsheets are:

  • Microsoft Excel, in the Microsoft Office office suite
  • Sun StarOffice Calc, in the StarOffice suite
  • OpenCalc, in the OpenOffice suite
  • IBM/Lotus 1-2-3 in the SmartSuite suite
  • Corel Quattro Pro in the WordPerfect suite
  • KSpread in the KOffice free suite from Linux

Examples in the following articles are based on the Microsoft Excel spreadsheet, but the other spreadsheets contain the same functionalities.



Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Introduction to Spreadsheet Concepts » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Best answers for « Introduction to Spreadsheet Concepts » in :
Spreadsheets - Worksheets Show The Concept of a Worksheet Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a...
Spreadsheet - Functions Show The Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheet - Formulas Show Introduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Network concept ShowNetwork concept Intro Computer Network Intro A network is a general term referring to a set of related elements or entities linked to each other. The coexistence of these elements is defined by the communication or exchange processes...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Download OpenOffice ShowOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007 formats). Writer Calc ...
Download Spreadsheet Converter ShowIt is not always necessary to create a complex script in order to insert a form into a web page. The use of some line of Javascript of Spreadsheet Converter allows you to use online form. Spreadsheet Converter is a program to create a form for a...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...