Flux rss
They need your help
Excel Interface

Spreadsheets - Worksheets

Cells
Bookmark Bookmark & Share
Foglio elettronico - I fogli di calcolo Folha de cálculo - As folhas de cálculo Tabellenkalkulation - Worksheets Tableur - Les feuilles de calcul

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 column is called a cell. A cell is therefore represented by a number and a letter.

A worksheet can contain up to 65,536 lines and 256 columns, more that 17 million cells.

Each of the cells on a worksheet may contain values. These values are entered directly (numbers, text, date, etc.) or are automatically calculated by the spreadsheet. This is referred to as formulas, meaning expressions that calculate a value in function of one or more values in other cells on the worksheet.

Spreadsheets have a large number of integrated functions for math calculations, statistics, etc.

Here is an example of a worksheet that contains student's grades for which the spreadsheet automatically calculates the averages:

worksheet display



Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheets - Worksheets » 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.
Spreadsheet - Formulas 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... en.kioskea.net/contents/tableur/tabformules.php3
Spreadsheets - Cell Selection Cell 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... en.kioskea.net/contents/tableur/tabcellselect-1.php3
Spreadsheets - Conditional expressions What 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... en.kioskea.net/contents/tableur/tabcond.php3
[Excel]Storage name and path of a spreadsheet[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)... en.kioskea.net/faq/sujet-1152-excel-storage-name-and-path-of-a-spreadsheet
Inserting an animated gif in ExcelInserting 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... en.kioskea.net/faq/sujet-1402-inserting-an-animated-gif-in-excel
Import contacts from Excel to OutlookImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and... en.kioskea.net/faq/sujet-1930-import-contacts-from-excel-to-outlook
Results for Spreadsheets Worksheets
Index and matching 2 different spreadsheetsHello, i am trying to index and match two diffrent excel spreadsheets. one has the same info on it as the other except for one column. i'm trying to add that data over on the other spreadhseet becaue not all the names are on the spreadsheet i'm trying... en.kioskea.net/forum/affich-92629-index-and-matching-2-different-spreadsheets
Excel spreadsheetHello, I am trying to create a spreadsheet for employees schedule. I want it to be able to give me the total hours at the end of each week. It is a montly schedule with their names. Also, I want to be able to put a code in representing the shift they... en.kioskea.net/forum/affich-29731-excel-spreadsheet
Import webpage data into Excel spreadsheetHello, I am attempting to import the web page data from "http://bet1.hkjc.com/..." through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks. en.kioskea.net/forum/affich-31834-import-webpage-data-into-excel-spreadsheet
Results for Spreadsheets Worksheets
Download Excel ViewerWith Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed. You can also copy data from Excel Viewer to another program. en.kioskea.net/telecharger/telecharger-52-excel-viewer
Download OpenOffice.orgOpenOffice 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 ... en.kioskea.net/telecharger/telecharger-56-openoffice-org
Download Family Home Budget 2008Family Home Budget 2008 is a budget manager designed for family usage. The application includes an interface with spreadsheets and the expenses are monthly classified. You just enter the daily, weekly figures and the application does the rest. The... en.kioskea.net/telecharger/telecharger-1875-family-home-budget-2008
Results for Spreadsheets Worksheets
Microsoft Office Home and Student 2007 - Complete package - 3 PC in one household - non-commercial -Microsoft Office Home and Student 2007 Office Home and Student 2007 provides software essentials that enable you to easily create great-looking documents, spreadsheets, and presentations, and manage your notes. Not for use in any commercial, non... en.kioskea.net/guide/242292248-microsoft-office-home-and-student-2007-complete-package-3-pc-in-one-household-non-commercial-cd-win-english
CRYSTAL DECISIONS Xcelsius Engage 2008 - Licence - 1 named user - WinCreate engaging and interactive dashboards with Xcelsius Engage 2008. Xcelsius Engage is the perfect way to get started in the exciting area of dashboarding. It lets you create business dashboards and data presentations from spreadsheets, corporate... en.kioskea.net/guide/655237010-crystal-decisions-xcelsius-engage-2008-licence-1-named-user-win
NUANCE PDF Converter - ( v. 5 ) - complete package - 1 user - CD - Win - Englishv ., PDF Converter is the world's most accurate and best selling method for turning existing PDF files into fully-formatted documents, forms and spreadsheets - complete with text, columns, tables and graphics. Precise conversion technology allows you... en.kioskea.net/guide/656589454-nuance-pdf-converter-v-5-complete-package-1-user-cd-win-english
Results for Spreadsheets Worksheets
New software makes iPhones spreadsheet-friendlyUS software developer MeLLmo has released a free application that turns iPhones into powerful tools for analyzing spreadsheets and reports, enhancing the appeal of Apple mobile devices to businesses. The application, named RoamBi, intuitively... en.kioskea.net/actualites/new-software-makes-iphones-spreadsheet-friendly-12823-actualite.php3
Results for Spreadsheets Worksheets
Spreadsheets - WorksheetsThe 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... en.kioskea.net/contents/tableur/tabfeuille.php3
Spreadsheets - The Excel InterfaceExcel 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... en.kioskea.net/contents/tableur/tabinterface.php3
Spreadsheet - Text OperatorsConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell... en.kioskea.net/contents/tableur/tabtexte.php3
Results for Spreadsheets Worksheets