Flux rss
Reviews
They need your help

Spreadsheets - Data Entry

Cell Content

A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics:

  • a type, which means the intrinsic type of the data. There are generally three types of values:
    • numeric values, for example 3.1415927, 58%, or 1984.
    • alphanumeric values, for example Table2, Title or Name.
    • formulas, which means expressions that represent calculations based on data and performed by the spreadsheet.
  • a format that represents the way the spreadsheet displays the data. For example, if it is a number, the spreadsheet can be set to display it as an integer, as a decimal number (as well as the number of decimal places displayed), etc.
The cell may have a style, which means a particular visual appearance (font, size, color, border, etc.), independent of the value it contains.

Numeric Data Entry

When entering numbers in a cell (including monetary signs, percentages, etc.), the spreadsheet interprets the data as being numbers, which makes the use of mathematical formulas on the data possible. By default (without action on your part), the data recognized as being numbers will be right justified in the cell.

numeric data entry in the spreadsheet

Alphanumeric Data Entry

When entering letters in a cell, the spreadsheet interprets the data as being alphanumeric, thus blocking the option of using mathematical tools on the data. By default (without action on your part), the data recognized as being alphanumeric will be left justified in the cell.

alphanumeric data entry in the spreadsheet

Entering a Formula

Formulas are expressions that, when they are interpreted by the spreadsheet, allow calculations to be performed using data present in other cells.

To enter a formula in a cell, select the cell and start entering the formula starting with the "equal" sign (=)!

Nota Bene If the syntax of the formula entered after the equal sign (=) is not correct, the spreadsheet will display an error message preceded with the # character! In case of an invalid cell reference, the spreadsheet will display the #REF! value.

A formula may contain references to other cells, expressions, which means operators that allow simple operations to be performed on the values of other cells, as well as functions.

The integrated functions of the spreadsheet allow elaborated calculations to be performed based on values in the spreadsheet, like averages, rounding, etc.

Defining the Format of a Cell

The format of a cell defines the way its value will be displayed by the spreadsheet. To define the format of a cell, click on the cell, go to the menu Format > Cell and choose the Number tab (or Numbers in StarOffice). The spreadsheet will offer a series of formats divided by category:

Excel
StarOffice
formatting a cell in Microsoft Excel formatting a cell in StarOffice



Last update on Thursday October 16, 2008 02:43:17 PM.
This document entitled « Spreadsheets - Data Entry » 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 Data Entry

Data Entry down a colum Hello, I am trying to do some basic data entry using a scanner. I need to scan in over a thousand indiviudal components and I want to simply work straight down a colum. What I'm looking for is something that will automatically move to the next... en.kioskea.net/forum/affich-22254-data-entry-down-a-colum
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 - Worksheets 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... en.kioskea.net/tableur/tabfeuille.php3

Results for Spreadsheets Data Entry

DUPLICATE ENTRY '127' FOR KEY 1DUPLICATE ENTRY '127' FOR KEY 1 If you are using MySQL and you are facing the error “duplicate entry ‘127’ for key 1” while trying to make an entry in your database table, do not panic. This should be linked to the following and can easily... en.kioskea.net/faq/sujet-983-duplicate-entry-127-for-key-1
Backup Outlook 2003 dataBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application... en.kioskea.net/faq/sujet-47-backup-outlook-2003-data
Connecting to an Ingres database with PHPConnecting to an Ingres database with PHP Getting started Download PECL Installation Windows Linux & Unix Getting connected This tip is based on following Ingres documentation: Getting started Ingres ® 2006 Release 2 for... en.kioskea.net/faq/sujet-923-connecting-to-an-ingres-database-with-php
More answers

Results for Spreadsheets Data Entry

Moving Data in excell sheetsI need some way to move data from one sheet to another automatically when a user selects an option. I have a spreadsheet for orders in a small business. I need to be able to let the employee select "pickup" and it moves the data from the orders sheet... en.kioskea.net/forum/affich-30171-moving-data-in-excell-sheets
Pretty Basic Excel Macro HelpHello, I am writing a macro (which will be used to create a VB6 program) in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro... en.kioskea.net/forum/affich-15106-pretty-basic-excel-macro-help
Excel Macro HelpHello, I am trying to create a macro within Excel 2003, which will extract data from a Text document into an Excel spreadsheet and sort the data as required. This is made slightly more difficult by the inconsistency in the data which is explained... en.kioskea.net/forum/affich-30377-excel-macro-help
More answers

Results for Spreadsheets Data Entry

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 Zilla Data NukerBy abolishing files or sensitive or contaminated files, it is possible that fragments stay on the hard disk. These rags can again harm your system if they are not correctly abolished. Zilla Data Nuker abolishes not used files which take of the place... en.kioskea.net/telecharger/telecharger-506-zilla-data-nuker
Download Database Designer Platinum EditionDatabase Designer is a program for creating databases. It requires no programming knowledge. The application offers many tools: additions of fields, images, checks bugs correction syntactic and much more. It also allows the export of basic HTML, text... en.kioskea.net/telecharger/telecharger-1077-database-designer-platinum-edition
More answers

Results for Spreadsheets Data Entry

Hacker splashes data from six million Chileans on Internet: reportFile photo shows the view from the San Cristobal hill overlooking the Chilean capital, Santiago. A hacker broke into Chile's government sites mining data from six million people which he then posted on the Internet A hacker broke into... en.kioskea.net/actualites/hacker-splashes-data-from-six-million-chileans-on-internet-report-10363-actualite.php3
US-EU private data sharing agreement at hand: reportFile photo shows a United Airlines flight attendant serving passengers. The United States and European Union are close to an agreement to share private data of their citizens, including credit card information, travel history and internet browsing... en.kioskea.net/actualites/us-eu-private-data-sharing-agreement-at-hand-report-10494-actualite.php3
Facebook suffers first drop in British users: dataFacebook, the Internet social networking site, has suffered its first drop in British users in 17 months, according to data from web monitoring firm Nielsen Online. Facebook, the Internet social networking site, has suffered its first drop in British... en.kioskea.net/actualites/facebook-suffers-first-drop-in-british-users-data-10141-actualite.php3
More answers

Results for Spreadsheets Data Entry

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
Spreadsheets - Logic 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/tablogic.php3
More answers