Page 247 - open office
P. 247
DATA
UMERIC A PHA- UMERIC DATE/TIME FORMU A
Numeric Data
umeric data consist of digits ( – ), e (Exponential), decimal (.) and numeric operators like , -, /, , , .
Numeric data or values are aligned towards the right side in a cell. Numeric data are the operands on which
the formula is applied to perform arithmetic calculations. Operands refer to data on which the formula is
applied.
Alphanumeric or Text Data
Alphanumeric data is the data that is textual in nature. It refers to the data that is a combination of alphabets,
spaces, digits and/or other characters. Alphanumeric data is mentioned within double-quotes “ ”. In Calc,
alphanumeric data is aligned (by default) towards the left side of the cell and is generally not meant for
calculation.
Date and Time
‘Calc’ displays date as sequential numbers known as Serial Values. The time is displayed as a fractional part.
Date and Time are values and therefore can be added or subtracted and can be included for other calculations.
They are aligned (by default) towards the right side of the cell.
Formula
A formula is an expression that helps to perform arithmetical calculation and also executes non-arithmetical
tasks. It consists of the operands and operators that operate on the data. Formula has to be expressed with
prefix before the operator/data.
CREATING A WORKBOOK
To work in ‘Calc’, the user needs to know how to work with Workbook. ‘Calc’ opens with a new workbook
named Untitled1 as the default workbook where the user can begin to work or create a new workbook. To
do so:
Step 1: Click on the ‘File’ menu and select the option ‘New’.
Step 2: A sub-menu appears. Click on ‘Spreadsheet’.
Or Click on the ew button from the Standard Toolbar.
Step 3: A new workbook named Untitled 1 appears on the screen.
Working with Spreadsheet 24

