| PreviousCells Selection | Spreadsheets - Data Entry | NextFormulas |
A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics:
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.
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.
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 (=)!
 |
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.
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:
 |
 |
Create a macro to pull data out of another spreadsheet Data from sxs card pcmcia Data transmission Digital data transmission Display dynamic data in web format form spreadsheet Excel compare data in two separate spreadsheets Excel macro data from another spreadsheet Excel spreadsheet carry data from one worksheet to another How do i see if data is on both spreadsheets excel How to format excel spreadsheet data How to reference one excell spreadsheets data in another spreadsheet In spreadsheet the vertical data is called: Listing data on a spreadsheet Lookup cell data compare with data in another spreadsheet and return value from column Packet data not available Pci data acquisition and signal processing controller Spreadsheet formulas Spreadsheet worksheet
