Flux rss
Reviews
They need your help

Spreadsheets - Worksheets

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.

Results for Spreadsheets Worksheets

Spreadsheets - 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. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3
Spreadsheets - The Excel Interface 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 document is called a file... en.kioskea.net/tableur/tabinterface.php3
Spreadsheet - Text Operators 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 value B15 ("Total TTC") is... en.kioskea.net/tableur/tabtexte.php3

Results for Spreadsheets Worksheets

[ExcelStorage 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) Upon... en.kioskea.net/faq/sujet-1152-excelstorage-name-and-path-of-a-spreadsheet
[VBA]Updating a procedure or function[VBA]Updating a procedure or function Managing a workbook,provided that only the standard functions of the spreadsheet are available,is a very difficult process. The logical step is to make use of Visual Basic Applications (VBA).... en.kioskea.net/faq/sujet-1176-vba-updating-a-procedure-or-function
Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
More answers

Results for Spreadsheets Worksheets

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
EXCEL CVS data to a custom spreadsheetHello, I download a CVS file from an investment site and transfer the variables to a custom spreadsheet. The problem is that the variables will not always be in the same place on th CVS file. This corrupts the custom spreadsheet. How can I track the... en.kioskea.net/forum/affich-38065-excel-cvs-data-to-a-custom-spreadsheet
Spreadsheet solutionsHello, i am unable to install spreadsheet solutions in my workbook(first i opened workbook-right clicked on sheet1,sheet2... and after right click,u'll find two tabs..second tab is for what i want..spreadsheet solutions--select that then when u c... en.kioskea.net/forum/affich-36105-spreadsheet-solutions
More answers

Results for Spreadsheets Worksheets

Download OpenOfficeOpenOffice 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... en.kioskea.net/telecharger/telecharger-56-openoffice
Download NeoOfficeNeoOffice is a complete set of applications of office program for Mac OS X, including a word processor, a spreadsheet, drawing applications and display. Based on OpenOffice.org office suite, Neooffice includes numerous of native Mac features and can... en.kioskea.net/telecharger/telecharger-1459-neooffice
Download Option Trading WorkbookOption Trading Workbook carries an estimate price of all options Greeks. The spreadsheet enables the user to enter up to 10 options for evaluating combinations of price. The calculations are made in Visual Basic and all the code used is fully... en.kioskea.net/telecharger/telecharger-1299-option-trading-workbook
More answers

Results for Spreadsheets Worksheets

Spreadsheet - Functions 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 functions that have analysis tools,... en.kioskea.net/tableur/tabfonc.php3
Spreadsheets - Introduction 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... en.kioskea.net/tableur/tablintro.php3
Spreadsheet - 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 a cell. A formula is used... en.kioskea.net/tableur/tabformules.php3
More answers